Help Table of Contents

Client Help

  1. User Types and Roles
  2. Pro User
    1. Pro Workflow Overview
    2. User Workspace
      1. Welcome Panel
      2. Home Page
        1. Home Menu
          1. System Info
            1. Application Languages
          2. User Defaults
        2. App Toolbox
        3. Quick Start, Tutorials and Guides and Learning Hub
          1. Interactive Tutorials
        4. User Hub
          1. Navigate the User Hub
          2. User Hub Editor
      3. Bulletin Board
        1. Publication Board
        2. Alerts Board
        3. Workflow and Conversation Board
        4. Subscriptions Board
        5. Model Board
      4. Inbox
      5. App Tabs
        1. App Tab Home Menu
        2. App Tab Manager
        3. Quick Open
        4. Job Spooler
          1. Print and Export Summary
        5. Query Benchmarks
        6. Tab Menu
        7. Keyboard Shortcuts
      6. Common App Interface
        1. Color Picker
        2. Clipboard Tools
        3. Saving Content
          1. Assigning Content Access
        4. Print and Export
          1. Printing from Embedded Content
        5. Subscriptions
          1. Configure Subscriptions
        6. Content Scheduling
          1. Define The Schedule
          2. Triggered Schedule Launch
            1. On Demand Schedules
          3. Scheduled Distribution
            1. Bulletin Board Distribution
            2. Email Distribution
            3. Phone Distribution
            4. Webhook Distribution
              1. Channels Dialog
              2. Webhook for Microsoft Teams
              3. Webhook for Slack
    3. Content Management
      1. Accessing Content
      2. Content Manager
        1. Content Explorer
          1. Content Folder Structures
        2. Content Item Mechanics
        3. Favorites
        4. Recents
        5. Most Used
        6. User Recommended
        7. Auto Recommended
        8. Content Search
      3. Content Actions and Tools
        1. Maintenance Mode
        2. Presentation Launcher
        3. Copy-Paste
        4. Cut-Paste or Move
        5. Delete, Purge and Restore
        6. Run Slide Show
        7. Print Folder
        8. Change Description
        9. Import and Export
        10. Lineage
        11. Open Related Content
        12. Action Panel
        13. Metadata Panel
        14. Content Tagging
        15. Content Versioning
        16. Copy URL Link
        17. OData Feed
        18. Embed Snippet Generator
        19. Audit Trail (CMS)
        20. Content Roles Panel
          1. Cross Tenancy Options
        21. Data Source Changer
        22. Structure Analyzer
        23. Scheduling and Subscriptions
        24. Alerts Manager
        25. Migration Wizard
      4. Materialized Data Manager
        1. Managing Materialized Data
          1. Data Server Manager
          2. Database Manager
          3. Data Model Manager
      5. Schedule and Subscription Manager
    4. Pro Apps
      1. Model
        1. Data Modeling Concepts
          1. Model Files vs Deployed Models
          2. External Models vs Pyramid Models
          3. Data Flows vs Semantic Models
        2. Smart Modeling
          1. New Smart Model
          2. Smart Modeling Heuristics
          3. Manage Smart Models
            1. Open And Edit Smart Models
            2. Save Smart Models
            3. Secure Smart Models
            4. Rerun Smart Models
        3. Model Lite
          1. New Lite Model
            1. Target
            2. Data
            3. Tables
            4. Columns
            5. Hierarchies
            6. Finish and Build
            7. Model Lite Heuristics
          2. Manage Lite Models
            1. Open Edit Lite Models
            2. Save Lite Models
            3. Rerun Lite Models
        4. Direct Model
          1. Servers
          2. Schema Display
          3. Relationships and Joins
          4. Managing Direct Models
            1. Save a Direct Model
            2. Open and Edit a Direct Model
            3. Process a Direct Model
            4. Rerun Direct Models
        5. Model Pro
          1. Model Pro Examples
          2. Master Flow
            1. Master Flow Interface
            2. General Nodes
              1. Data Flow
              2. SQL Script
              3. Data Model
              4. Set Variable
              5. Rest APIs
              6. Pyramid Event
              7. Command Line Support
              8. On Demand Schedules
              9. Wait
            3. Looping Steps
              1. For Loop
              2. For Each Loop
              3. While Loop
            4. Conditional
              1. Conditional Node
              2. Switch Statement
            5. Messaging
              1. Email
              2. SMS
            6. Master Flow Validation
          3. Data Flow
            1. Data Flow Interface
              1. Data Flow Ribbon
              2. Properties
              3. Node Selection
              4. Datasource Preview
                1. Column Statistics
              5. Variables
                1. Variables Panel
                2. SQL Variables Vs Static Variables
                3. Incremental Loading
                4. Inject Variables
              6. Workspace Layout
              7. Split Nodes
            2. Sources
              1. Data Sources and Targets
              2. Direct Query vs Ingested Data
              3. Use Existing Semantic Model
              4. File Sources
                1. Pyramid Reports
                2. Access
                3. Excel
                4. Google Sheets
                5. Provide a JSON File Source
                6. Multi Files
                7. SAS Data Set Source
                8. Text File Sources
                9. XML File Source
              5. Relational Sources
                1. Pyramid In Memory Database
                2. SAP HANA Datasource
              6. BigData Sources
                1. Adding Big Query as a Data Source
                2. MongoDb Datasource
              7. Cloud Sources
                1. Amazon S3
                2. Azure Blob
                3. Box
                4. Facebook Data Source
                5. Google Analytics (GA4)
                6. RSS
                7. SalesForce
                8. SharePoint
                9. SFTP (SSH) and FTP
                10. X (Twitter) Data Source
              8. Other Sources
                1. ODBC
                2. ODBC Direct
                3. OData Datasource
                4. Date Range Source
                5. Scripted Sources
                  1. Python Source
                  2. R Source
            3. Data Flow Targets
              1. Target Tables
              2. Pyramid IMDB
              3. File Targets
                1. Amazon S3
                2. Azure Blob
                3. Box
                4. CSV
                5. Excel
                6. Parquet
                7. SFTP (SSH) and FTP
                8. Folder Path Expression
              4. Relational Targets
                1. Custom Target Schema
                2. Execute a Script
              5. Big Data and Unstructured Targets
            4. Select
              1. Query
              2. Table
              3. Multi Tables
              4. Bottom N
              5. Top N
            5. Preparation
              1. Add Date/ Time
              2. Add Sequence
              3. Date Range
              4. Distinct
              5. Filter
              6. GeoCode
              7. Materialized Masking
              8. Modify Case
              9. Pivot
              10. Random Number
              11. Remove Duplicates
              12. Sort
              13. Summarize
              14. Time Intelligence
              15. Unpivot
            6. Gen-AI
              1. LLM Translate
              2. LLM Sentiment
              3. LLM General
            7. Column Operations
              1. Calculated Columns
                1. Custom Column PQL Editor
              2. Combined Columns
              3. Convert Columns
              4. JSON Extract
              5. Rename Columns
              6. Reorder Columns
              7. Split Columns
              8. Add Date Unit
              9. Date Difference
              10. Replace
              11. String Left
              12. String Right
              13. Substring
              14. Trim
              15. Aggregate FX
              16. Math FX
              17. Trig FX
            8. Joins
              1. Merge Join
              2. Union Join
            9. Machine Learning
              1. Machine Learning Functions
                1. Decision Tree
                2. Naïve Bayes
                3. Regression Trees
              2. Tensor Flow
              3. Machine Learning Nodes
              4. Machine Learning Examples
            10. Scripting
              1. Scripting Mechanics
                1. Scripting Inputs and Outputs
                  1. Data Frame Support
                2. Learn and Predict Scripts
                  1. Python Learn and Predict Examples
                3. Save Machine Learning Models
                4. Generate Your Script
                  1. Explain Script
                5. Marketplace
                  1. Marketplace Scripts
                    1. Sentiment Analysis Example
                    2. Basket Analysis Example
                6. Shared Scripts
                7. Virtual Scripting Environments
              2. Python Scripting
              3. R Scripting
            11. Validate Data Flow
            12. Model Transfer Cleanup
          4. Data Modeling
            1. Model Ribbons
              1. Configuration Ribbon
              2. Tables Ribbon
              3. Columns Ribbon
              4. Hierarchy Ribbon
            2. Configuration
              1. MS Tabular Models
              2. Auto Indexing
              3. Query Caching
            3. Tables Panel
              1. Relationships and Tables
              2. Relationship Table Editor
              3. Sync Settings
              4. Connector Types
              5. Context Menus and Properties
              6. Auto Table Update
              7. Automatic Column Handling
              8. Joins
                1. Heuristics
                2. Join Keys
                3. Bidirectional Joins
                4. Join Validation
              9. Columns
                1. Column Visibility
                2. Column Description
                3. Data Catalog
                4. Column Folders
                5. Column Categories
                6. Dynamic Data Masking
              10. Measures
                1. Measure Types
                  1. Cumulative Measure
                  2. Semi Additive Measures
                2. Measure Formats
                3. Measure Folders
                4. Measure Descriptions
                5. Multi-Measures
                6. Measure Editor
                7. Units and Currency
              11. Primary Keys and Indexing
              12. Special Tables and Columns
                1. Aggregate Tables
                2. Security Tables and Columns
                3. Distribution Tables and Columns
                4. Add Custom Query Table
            4. Columns
              1. Column Configuration
                1. Configure Custom Maps
              2. Multi-Measures Panel
              3. Column Sorting
              4. Virtual Column Calculations
                1. Calculated Columns Panels
                2. Calculated Columns Settings
                3. Calculated Column Walk Through
            5. Hierarchy Panel
              1. Hierarchy Panel Mechanics
                1. Hierarchy Metadata
                2. Ragged Hierarchies
                3. Parent Child Hierarchies
                  1. Build Parent Child Hierarchies
                  2. Parent Child Hierarchy Examples
            6. Translations Panel
              1. Translations Attribute
          5. Model Processing
            1. Quick Discovery
            2. Schedule a Data Model
            3. Node Execution Status
            4. Progress Panel
          6. Security
            1. Security Settings
            2. Data Source Management
          7. Model Management
            1. Open and Edit a Model
            2. Save Models
            3. Printing and Documentation
      2. Discover
        1. Viewing Discover Content
        2. Natural Language Querying
          1. Accessing NLQ in Discover
          2. NLQ Chatbot
          3. Example: Build a Visual using the Chatbot
          4. Writing NLQ Questions
            1. NLQ: Advanced Intelligence
            2. NLQ: Visualizations
          5. Managing NLQ Discoveries
        3. Smart Discover
          1. Access Smart Discover
          2. Smart Discover Workspace
            1. Item Selection Bar
            2. Visualization Picker
              1. Smart Visualization Mechanics
            3. Design Panel
          3. Build Smart Discoveries
            1. Values
            2. Dimensions
              1. Custom Selections
              2. Sort and Filter Hierarchies
              3. Working with Dates
                1. Date-Time Calculations
                2. Date Parts
            3. Data Filters
            4. Visualizations
              1. Quick Styles
                1. Quick Styles
                2. Quick Styles for Grids
                3. Quick Styles for Cartesian Charts
                4. Quick Styles for Segment Charts
                5. Quick Styles for Plotted Charts
                6. Quick Styles for Maps
          4. Manage Smart Discoveries
            1. Save and Share
        4. Discover Lite
          1. Access Discover Lite
          2. Discover Lite Workspace
            1. Drop Zones
            2. Discover Lite Ribbon
              1. Axis Options
              2. Data Labels
              3. Data Points
              4. Grid Lines
            3. Model Metadata and Trees
          3. Build Lite Discoveries
            1. Drop Zones
            2. Visualizations
              1. Quick Styles
            3. Dynamic Interactions
            4. Quick Calculations
            5. Context Calculations
          4. Manage Lite Discoveries
          5. Conversations
        5. Discover Pro
          1. Access Discover Pro
            1. Pyramid Models
              1. Direct Model on a Database
              2. Direct Model with SQL
            2. Microsoft Models
            3. SAP Models
              1. SAP HANA Views
              2. SAP BW Models
          2. Discover Pro Workspace
            1. Discover Pro Ribbons
              1. Panel Layout
              2. New Report
              3. User Defaults
            2. Panels
              1. Drop Zones Panel
              2. Data Model Trees
                1. Dimensions and Hierarchies
                  1. Hierarchy Types
                  2. Hierarchy Properties
                  3. Measure Group Filtering
                  4. Alternative Captions
                    1. SAP BW Technical Names
                2. Elements
                3. Measures
                  1. Measure Properties
                4. Refresh Metadata
                5. Languages
              3. Visualizations
              4. Content Panel
              5. Query Metadata Panel
              6. Performance Dialog
              7. Smart Insights
          3. Navigating and Querying Data
            1. Building Queries
              1. Using Data Model Metadata
                1. Using the Hierarchies Tree
                  1. Using Attribute Hierarchies
                  2. Using Regular Hierarchies
                  3. Using Drill Path Hierarchies
                  4. Using Parent-Child Hierarchies
                  5. Using Geospatial Hierarchies
                  6. Using Date-Time Hierarchies
                  7. Using Image URL Hierarchies
                  8. Using URL Hierarchies
                  9. Using Hidden Hierarchy Properties
                2. Using the Elements Tree
                  1. Elements Tree Context Menu
                  2. List Builder
                  3. Members Search
                3. Using the Measures Tree
              2. Drop Zones
                1. Values Drop Zone
                  1. Colorize Values
                  2. Shapify Values
                2. Column and Row Drop Zone
                3. Categories Drop Zone
                4. Trellis Drop Zones
                5. Color Drop Zone
                6. Shape Drop Zone
                7. Size Drop Zone
                8. Labels Drop Zone
                9. Tooltip Drop Zone
                10. Indicator and Status Drop Zones
                11. Motion Drop Zone
                12. Details Drop Zone
                13. Map Location / Shape Drop Zone
                14. Filters Drop Zone
                  1. Calendar Slicers
                    1. Calendar Pickers
                    2. Calendar Slicer Settings
                  2. Tree Slicer
                  3. Slicer Limits
                  4. Cascading Slicers
                    1. Manually Building Cascading Slicers
                  5. Slicer Settings
                  6. Slicer Styles
                  7. Slicer Formatting
                  8. Background Filters
                  9. Making Slice Selections
                  10. Bookmarks
                  11. Pre-Query Slicers
                    1. Manage Pre-Query Bookmarks
                15. More Drop Zone Options
                  1. Copy or Move
              3. Building Visualizations
                1. Raw Results
                2. Grids
                  1. Matrix Grid
                  2. Tabular Grid
                3. Cartesian Charts
                  1. Column Chart
                  2. Stacked Column Chart
                  3. Stacked 100 Column Chart
                  4. Marimekko Chart
                  5. Bar Chart
                  6. Stacked Bar Chart
                  7. Stacked 100 Bar Chart
                  8. Tornado Chart
                  9. Multi-Measure Charts
                  10. Combo Charts
                  11. Line Chart
                  12. Point Charts
                  13. Lollipop Charts
                  14. Area Chart
                  15. Stream Chart
                4. IBCS-Like Charts
                  1. IBCS-Like Area Chart
                  2. IBCS-Like Column Chart
                  3. IBCS-Like Line Chart
                  4. IBCS-Like Lollipop Chart
                5. Segment Charts
                  1. Pie Chart
                  2. Doughnut Chart
                  3. Pyramid Chart
                  4. Funnel Chart
                  5. Multi-Measure Segment Charts
                6. Radar Charts
                7. Plotted Charts
                  1. Scatter Chart
                  2. Bubble Chart
                  3. Scatter Line Chart
                8. Advanced Charts
                  1. Tree Map Chart
                  2. Hierarchical Tree Map Chart
                  3. Circle Packing Chart
                  4. Hierarchical Circle Packing Chart
                  5. Sankey Chart
                  6. Word Cloud
                  7. Sunburst Chart
                  8. Icicle Chart
                9. KPI Charts
                  1. Gauges
                  2. Bullet Chart
                10. Maps
                  1. Bubble Maps
                  2. Shape Maps
                    1. Custom Maps
                  3. Geo Heat Map
                  4. Map Quick Styles
                  5. Geo-Boundary
                11. Other Charts
                  1. Candlestick Chart
                  2. Box and Whisker Chart
                  3. Waterfall Chart
                  4. IBCS-Like Waterfall Chart
                12. Custom Visuals
                13. Conditional Formatting
                  1. Conditional Formatting Context Menu
                  2. Conditional Formatting via Drop Zones
                    1. Value Driven Colors
                    2. Conditional Color Examples
                    3. Text Indicator
                  3. Conditional Formatting Dialog
                  4. Conditional Formatting Logic
              4. Running Queries
                1. Query and Report Reset
            2. Changing and Manipulating Queries
              1. Query Interactions
                1. Drill-Up and Drill-Down
                2. Dice, Add, Swap, and Remove
                3. Expand and Collapse
                4. Element and Data Point Selection
                  1. Focus and Descendants
                5. Fill the Blanks
                6. Quick Sort
                  1. Set Element Order
                7. Quick Filter
                8. Pivot
                9. Quick Totals
                10. Explain
                  1. Explain explained
                  2. Explain the Difference
                11. Extended Query Interactions
                12. Interactive Selections
              2. Query Functions
                1. Show or Hide Empties
                2. Totals
                3. Sorting
                4. Value Filtering
                5. Eliminations
                6. N-of-N
                7. Hide Query Info
              3. Advanced Query Functions
                1. Forecasting
                  1. Basic Forecasting
                  2. Advanced Forecasting
                    1. Custom Forecast Scripts
                2. Regression Functions
                3. Statistics
                4. Pareto
                5. Clustering
                6. Outliers
                7. Fill Blanks
            3. Calculations in Discover
              1. Quick Calculations
                1. Group Calculations
                2. Quick Formulas
                3. Quick Lists
                  1. Quick Variable Lists
                4. Quick Parameters
                  1. Quick Static Parameters
                5. Quick KPIs
                6. Managing Quick Calculations
                  1. Saving and Sharing Calculations
                  2. Internal Parameters
              2. Context Calculations
                1. Difference Context Functions
                2. Cumulative Context Functions
                3. Statistical Context Functions
                4. Advanced Analytic Context Functions
                5. Managing Context Calculations
                6. Customizing Context Calculations
              3. Custom Columns
                1. Aggregations
                2. Categorization
                3. Date Parts
                4. String Functions
                5. AI Driven Columns
                6. Managing Custom Columns
              4. Other Calculation Tools
                1. Time Calculation Wizard
                  1. To Date
                  2. Last n Periods
                  3. Periods
                    1. Full Period
                    2. Period On Period
                    3. Parallel Day
                    4. Parallel Period
                2. Variable Lists
            4. Query Options
              1. Query Settings
              2. Choose Language
              3. Model Colors and Formats
          4. Formatting and Design
            1. Copy Styles
            2. Reset Formatting
            3. Report Design
              1. Themes
              2. Report Title
              3. Background Color
              4. Notes
                1. AutoML Explanations
              5. Discover Runtime Settings
              6. Tooltip
              7. Auto-Colorize
              8. Member Color Lock
            4. Visualization Design
              1. Quick Styles
              2. IBCS-Like Charts
                1. IBCS-Like Area Chart
                2. IBCS-Like Column Chart
                3. IBCS-Like Line Chart
                4. IBCS-Like Lollipop Chart
                5. IBCS-Like Waterfall Chart
              3. Formatting Panel
                1. Grid Formatting
                  1. Matrix Grid
                    1. Alignment
                    2. Alternate Rows
                    3. Column Size
                    4. Expand Icons
                    5. Grid Borders
                    6. Grid Font
                    7. Grid Font Alignment
                    8. Grid Padding
                    9. Row Area Size
                    10. Total Formatting
                  2. Data
                  3. Columns and Rows
                  4. Contextual Formatting
                  5. Clear Custom Formatting
                2. Cartesian Chart Formatting
                  1. Cartesian Charts
                  2. Chart Padding
                  3. Plot Area
                3. Segment Chart Formatting
                  1. Explode
                4. Radar Chart Formatting
                  1. Radar Line Chart
                5. Plotted Chart Formatting
                  1. Plotted Charts
                  2. Axis Position
                  3. Reference Line
                6. KPI Chart Formatting
                  1. Gauge Formatting
                    1. Gauge Labels
                      1. Gauge Value
                    2. Gauge Shape
                    3. Gauge Shadow
                    4. Auto Fit Labels
                    5. Gauge Scale
                  2. Bullet Chart Formatting
                    1. Bullet Chart Indicators
                    2. Bullet Chart Scale
                7. Advanced Chart Formatting
                  1. Circle Packing Chart
                  2. Sankey Chart
                  3. Sunburst Chart
                  4. Tree Map Chart
                  5. Waterfall Chart Formatting
                  6. Word Cloud Chart
                8. Map Formatting
                  1. Auto Center Map
                  2. Bubble Map Formatting
                  3. Shape Map Formatting
                  4. Geo Heat Map Formatting
                  5. Map Colors
                  6. Map Default Labels
                  7. Map Labels
                  8. Geospatial Defaults
                  9. Scale Control
                  10. Zoom Control
                9. Custom Visuals
              4. Common Design Capabilities
                1. Axes
                2. Color
                3. Data Labels
                  1. Data Label Optimization
                4. Legends
                  1. Combined Color Shape Legend
                  2. Legend Formatting
                  3. Series Editing
                5. Line Style
                6. Multi Chart Title
                7. Opacity
                8. Scale to Fit
                9. Shapes and Data Points
                10. Trellis Axes
                11. Visual Optimization
              5. Design Tools from the Ribbons
                1. Quick Styles
                  1. Grid Quick Styles
                  2. Cartesian Chart Quick Styles
                  3. Segment Chart Quick Styles
                  4. Plotted Chart Quick Styles
                  5. Map Quick Styles
                2. Axis Options
                3. Custom Reference Line
                4. Chart Border Width
                5. Mini Map
                6. Range Slider
                7. Custom Trellising
                8. Data Points
                9. Font Size
                10. Font Color
                11. Image Size
                12. Motion
                13. Readability
                14. Row Limit
                15. Show Data Grid
          5. Extended Functionality
            1. Discovery Actions
              1. Action Panel
                1. Jump To URL
                2. JavaScript Actions
                3. Tooltip Actions
                4. Action Library (PQL)
              2. Cube Actions
              3. Manage Actions
            2. Alerts Builder
              1. Advanced Alerts
            3. Workflows and Conversations in Discover
              1. Start a Conversation
              2. Managing Workflows and Conversations
            4. SAP Parameters for BW and HANA
            5. Data Catalog Viewer
          6. Manage Discoveries
            1. Save and Share Discoveries
            2. Printing in Discover
            3. Discovery Subscriptions
            4. Open and Edit Discoveries
            5. User Settings
        6. Auto Discover
          1. Auto Discover Explained
      3. Formulate
        1. Common Formulate Workspace
          1. Formulate Panels
          2. Model Metadata in Formulate
          3. Script Editor
          4. AI Generated Script
          5. Quick Discovery
          6. Quick Logic
          7. Functional Selection
          8. Internal Parameters
        2. Formulas (Members and Measures)
          1. Formula Ribbon
            1. Marketplace
            2. Multi-lingual Formulas
            3. Choose Language
          2. Formula Properties
            1. MDX Properties
            2. Formatting by Cell in MDX
            3. Dynamic Captions
              1. Walk through: Build Dynamic Captions
          3. Preview Panels
          4. Formula Script Editor
          5. Formula Examples
            1. Percentage Markup Formula
            2. Yearly Sales Variance
            3. Formula in Script Mode
        3. Lists (Sets)
          1. List Ribbon
            1. Move to Start or End
          2. List Properties
          3. List Script Editor
          4. List Actions
            1. Add
              1. Standard List
              2. Measure List
              3. Range List
              4. Full Month
              5. Full Quarter
              6. Full Week
              7. Full Year
              8. Month to Date
              9. Parallel Period
              10. Quarter To Date
              11. Week To Date
              12. Year To Date
            2. Derive
              1. Except/ Remove
              2. Intersect
              3. Set Intersect
              4. Union
            3. Filter
              1. Bottom Count
              2. Bottom Percent
              3. Bottom Sum
              4. Contains
              5. Ends With
              6. Equals
              7. Filter
              8. First
              9. Last
              10. Starts With
              11. Top Count
              12. Top Percent
              13. Top Sum
            4. Sort
              1. Natural Order
              2. Order by Label
              3. Order by Selection
              4. Order by Value
            5. Fork
              1. If
              2. Switch
          5. List Examples
            1. Build a List
            2. List in Script Mode
        4. KPIs
          1. KPI Ribbons
          2. Building a KPI
            1. KPI Dynamic Bands
            2. KPI Script Editor
          3. Using KPIs
            1. Gauge Color Types
            2. Gauge Indicator Types
          4. Walk-throughs: KPIs
        5. Custom Columns
          1. Custom Column Ribbon
          2. Custom Column Properties
            1. Custom Column Settings
            2. Custom Column Measures
            3. Creating Measures
          3. Custom Column Panels
            1. Preview Panel
            2. Model Attributes Panel
          4. Custom Column Examples
            1. Walk through: Create New Attribute
            2. Walk through: Create New Measure
            3. Walk through: Custom Column in Script Mode
        6. Parameters
          1. Parameter Designer
          2. Dynamic List Parameters
          3. Parameter Types
            1. Discrete Parameters
            2. Continuous Parameters
            3. Free Form Parameters
        7. Scripting
          1. Shared Scripting
        8. Custom Visualizations
          1. Custom Visual Ribbon
      4. Present
        1. Smart Present
        2. Present Lite
          1. Access Present Lite
          2. Present Lite Workspace
            1. Present Lite Actions Menu
            2. Present Lite Design
            3. Present Lite Panels
          3. Build Lite Presentations
            1. Add Content
            2. Miniature Visualizations
            3. New Slicer
            4. Dynamic Text Fields
            5. Import Images
            6. Static Text
            7. Shapes
            8. Interactions
          4. Run Lite Presentations
            1. Slicers
            2. Cross-Filtering and Highlighting
          5. Manage Lite Presentations
        3. Present Pro
          1. Presentation Overview
            1. Present Ribbons
            2. Present Workspace
            3. Slides and Sections
            4. Context Menus
            5. Building Presentations
              1. Build a Presentation
              2. Build a Storyboard with the Chatbot
              3. Page Layout and Design
              4. Grouping
          2. Presentation Design
            1. Theme, Device, and Layout
              1. Tooltip Presentations
              2. Slide Formatting and Layout
              3. Auto Layout
              4. Visual Formatting
                1. Format Multiple Items
                2. Formatting Panel
                3. Unlink Content
                4. Range Slider
                5. Scaling and Auto Fit
                6. Auto Fit Labels
                7. Miniature Visualizations
                8. Presentation and Publication Legends
                9. Layout Containers
                  1. Matrix Table Layout
                  2. Scrollable Layout
                  3. Mini-Tab Layout
                    1. Conditional Display
              5. Panels
                1. Panel Settings Dialog
                2. Panel Tools
              6. Grid Sizing
            2. Master Page Templates
              1. Navigation Options
              2. Web Page Assets
            3. Refresh Snapshots
            4. AI Image Generator
          3. Presentation Analytics
            1. Presentation Slicers
              1. New Slicer
              2. Advanced Slicer Wizard
              3. Slicer Settings
              4. Slicer Formats
              5. Measure Slicers
              6. Hidden Slicers
              7. Disable Slicers
              8. Detach Slicer
              9. Duplicate Slicers
              10. Edit Slicers
              11. Delete Slicers
            2. Interactions and Filtering
              1. Interaction Manager
              2. Auto Interact
              3. Show and Edit Interactions
              4. Remove Interactions
              5. Interaction Picker
              6. Integrate Slicers with Dynamic Images
              7. Cross-Visual Interactions
                1. Cross-Filtering
                2. Cross Filtering Slicers
                3. Cross Highlighting Slicers
              8. Present Targets
              9. Range Slicers in Present
              10. Cross Model Mapping
            3. Assets
              1. Add Dynamic Text
                1. Dynamic Text Editor
                2. Auto Translate
                3. Text Formatting
                4. Dynamic Place Holder
                5. Dynamic Tooltips
                6. Empty Strings
                7. Graphic Text
                8. Add Text Fields
                  1. AI Slide Insights
                  2. Model Processed Date
              2. Dynamic Jump Buttons
                1. Jump to Slide
                2. Jump to Content Item
                3. Jump to URL
                4. Execute JavaScript
                5. Publication Print
              3. Dynamic Web Panels
              4. Dynamic Clipboard Tools
          4. Presentation Runtime
            1. Present Runtime Settings
            2. Presentation Menu
            3. Explanations in Present
            4. OData Link
            5. Bookmarks
              1. Manage Bookmarks
            6. Pre-Query Slicers (Present)
            7. Presentation Actions
              1. Slicer Actions
              2. Tooltip Actions
              3. Tooltip Presentations
            8. Presentation Timer
            9. Alerts
            10. Workflows in Present
            11. Analyze Further
            12. Printing in Present
            13. NLQ Chatbot (Present)
              1. Explore a Storyboard using Chatbot
            14. Smart Insights
            15. Presentation Subscriptions
      5. Publish
        1. Smart Publish
        2. Publish Lite
          1. Access Publish Lite
          2. Publish Lite Workspaces
            1. Publish Lite Ribbon
            2. Publish Lite Toolbox
            3. Publish Lite Pages
            4. Publish Lite Canvas
          3. Build Lite Publications
            1. Add Content
            2. Add Slicers
            3. Add Static Text
            4. Dynamic Text
              1. Dynamic Text Fields
              2. Dynamic Placeholders
            5. Table of Contents
            6. Add Static Graphics
            7. Context Menus
            8. Interaction Manager
            9. Themes
            10. Cover Pages
            11. Align and Distribute
            12. Grouping
          4. Manage Lite Publications
            1. Save Lite Publications
            2. Print and Export
            3. Subscriptions
            4. Link Back to Live Content
        3. Publish Pro
          1. Publication Overview
            1. Building Publications
              1. Publication Workspace
              2. Publish Ribbons
              3. Context Menus
              4. Text and Shapes
              5. Build a Publication
              6. Build a Publication with the Chatbot
          2. Publication Design
            1. AI Image Generator
            2. Refresh Snapshots
            3. Page Sizes and Orientation
            4. Content Layout Tools
            5. Publication Templates
            6. Auto Layout Publish
            7. Content Captioning
            8. Publication Legends
            9. Text Fields
            10. Flow Visual
            11. Grid Sizing
            12. Unlink Content
            13. Formatting Panel
            14. Show Warnings
            15. Layout Containers
              1. Matrix Table Layout
              2. Conditional Display
          3. Publication Analytics
            1. Publication Slicers and Interactions
              1. New Quick Slicer
              2. Advanced Slicer Wizard
              3. Page Repeater
              4. Interaction Manager
              5. Range Slicers in Publish
              6. Cross Model Mapping
            2. Add Dynamic Text to Publications
              1. Dynamic Text Editor
              2. Text Formatting
              3. Empty Strings
              4. Dynamic Place Holder
          4. Publishing and Distribution
            1. Printing in Publish
            2. Subscribe to Publication
            3. Scheduled Publishing
            4. PDF Bookmarks
            5. Link-Back
            6. Distribution
              1. Bulletin Board Distribution
              2. Email Distribution
              3. Static Distribution List
              4. Dynamic Distribution
                1. Distribution via File Mapping
                  1. Walkthrough: File Mapping
                2. Distribution via Data Mapping
                  1. Walkthrough: Data Mapping
              5. Triggers
            7. Access Scheduled Publications
      6. Illustrate
        1. Illustrate Ribbons
        2. Dynamic Images
          1. Dynamic Graphic Properties
          2. Import Images
          3. Build Dynamic Images
        3. Dynamic Text
          1. Dynamic Text Properties
          2. Build Dynamic Text
          3. Empty Strings
          4. Graphic Text
        4. Dynamic Tooltips
        5. Dynamic Functions
        6. Use Dynamic Images and Texts
      7. Tabulate
        1. Tabulate Pro
          1. Accessing Tabulate
            1. Viewing Tabulate Content
            2. How to Enable/Disable Tabulate
          2. Tabulate Workspace
            1. Tabulate Canvas
              1. Zoom in or out of a sheet
            2. Tabulate Ribbons
            3. Tabulate Toolbox
            4. Tabulate Status Bar
            5. Tabulate Sheets
            6. Hiding and Showing Sheets
          3. Working with Spreadsheets
            1. Data Entry and Cells
              1. Rows and Columns
              2. Resizing Rows and Columns
              3. Hide and Show Rows and Columns
              4. Freeze Panes
              5. Clipboard
              6. Named Ranges
              7. Working with Formulas
                1. More Formula Details
                2. Formula Bar
                3. Formula Wizard
            2. Formatting
              1. Gridlines
              2. Headers
              3. Themes
              4. Cell Formatting
              5. Number Formatting
              6. Tables
              7. Filtering and Sorting
              8. Conditional Formats in Tabulate
                1. Applying Conditional Formats
            3. Using Live Data
              1. Importing Data and Content
                1. Smart Report
                2. Discover Lite
                3. Importing Existing Spreadsheets
              2. Slicers
                1. Attaching Slicers
                2. Pre-Query Slicers (Tabulate)
              3. Parameters
                1. Attaching Parameters
                2. Editing Parameters
                3. Internal Parameters
              4. Managing Data Sources
                1. Cross Model Mapping
              5. Blending Queries
          4. Creating Tabulate Visuals
            1. Drop Zones
            2. Formatting Panels
            3. Panel Layout
          5. Embedding in Present and Publish
          6. Managing Tabulations
            1. Saving Tabulations
            2. Printing and Exporting
            3. Mobile Access
          7. Solve Overview
            1. Optimization Explained
            2. Using Solve
            3. Solve Panel
              1. Solve Advanced Settings
            4. Complete Solve Example
        2. Tabulate Lite
          1. Accessing Tabulate Lite
            1. Viewing Tabulate Content
            2. How to Enable/Disable Tabulate
          2. Tabulate Lite Workspace
            1. Tabulate Lite Canvas
              1. Zoom in or out of a sheet
            2. Tabulate Lite Ribbons
            3. Tabulate Lite Toolbox
            4. Slicers
            5. Tabulate Status Bar
            6. Tabulate Sheets
            7. Hiding and Showing Sheets
          3. Working with Spreadsheets
            1. Data Entry and Cells
              1. Rows and Columns
              2. Resizing Rows and Columns
              3. Hide and Show Rows and Columns
              4. Freeze Panes
              5. Clipboard
              6. Named Ranges
              7. Working with Formulas
                1. More Formula Details
                2. Formula Bar
                3. Formula Wizard
            2. Formatting
              1. Themes
              2. Cell Formatting
              3. Number Formatting
              4. Tables
              5. Filtering and Sorting
              6. Conditional Formats in Tabulate
                1. Applying Conditional Formats
            3. Using Live Data
              1. Importing Data and Content
                1. Smart Report
                2. Discover Lite
                3. Importing Existing Spreadsheets
              2. Blending Queries
          4. Creating Tabulate Visuals
            1. Drop Zones
            2. Formatting Panels
            3. Panel Layout
          5. Embedding in Present and Publish
          6. Managing Tabulations
            1. Saving Tabulations
            2. Printing and Exporting
            3. Mobile Access
  3. Analyst User
    1. User Workspace
      1. Welcome Panel
      2. Home Page
        1. Home Menu
          1. System Info
            1. Application Languages
          2. User Defaults
        2. App Toolbox
        3. Quick Start, Tutorials and Guides and Learning Hub
          1. Interactive Tutorials
        4. User Hub
          1. Navigate the User Hub
          2. User Hub Editor
      3. Bulletin Board
        1. Publication Board
        2. Alerts Board
        3. Workflow and Conversation Board
        4. Subscriptions Board
        5. Model Board
      4. Inbox
      5. App Tabs
        1. App Tab Home Menu
        2. App Tab Manager
        3. Quick Open
        4. Job Spooler
          1. Print and Export Summary
        5. Query Benchmarks
        6. Tab Menu
        7. Keyboard Shortcuts
      6. Common App Interface
        1. Color Picker
        2. Clipboard Tools
        3. Saving Content
          1. Assigning Content Access
        4. Print and Export
          1. Printing from Embedded Content
        5. Subscriptions
          1. Configure Subscriptions
        6. Content Scheduling
          1. Define The Schedule
          2. Triggered Schedule Launch
            1. On Demand Schedules
          3. Scheduled Distribution
            1. Bulletin Board Distribution
            2. Email Distribution
            3. Phone Distribution
            4. Webhook Distribution
              1. Channels Dialog
              2. Webhook for Microsoft Teams
              3. Webhook for Slack
    2. Content Management
      1. Accessing Content
      2. Content Manager
        1. Content Explorer
          1. Content Folder Structures
        2. Content Item Mechanics
        3. Favorites
        4. Recents
        5. Most Used
        6. User Recommended
        7. Auto Recommended
        8. Content Search
      3. Content Actions and Tools
        1. Maintenance Mode
        2. Presentation Launcher
        3. Copy-Paste
        4. Cut-Paste or Move
        5. Delete, Purge and Restore
        6. Run Slide Show
        7. Print Folder
        8. Change Description
        9. Import and Export
        10. Lineage
        11. Open Related Content
        12. Action Panel
        13. Metadata Panel
        14. Content Tagging
        15. Content Versioning
        16. Copy URL Link
        17. OData Feed
        18. Embed Snippet Generator
        19. Audit Trail (CMS)
        20. Content Roles Panel
          1. Cross Tenancy Options
        21. Data Source Changer
        22. Structure Analyzer
        23. Scheduling and Subscriptions
        24. Alerts Manager
        25. Migration Wizard
      4. Materialized Data Manager
        1. Managing Materialized Data
          1. Data Server Manager
          2. Database Manager
          3. Data Model Manager
      5. Schedule and Subscription Manager
    3. Lite Apps
      1. Discover Lite
        1. Access Discover Lite
        2. Discover Lite Workspace
          1. Drop Zones
          2. Discover Lite Ribbon
            1. Axis Options
            2. Data Labels
            3. Data Points
            4. Grid Lines
          3. Model Metadata and Trees
        3. Build Lite Discoveries
          1. Drop Zones
          2. Visualizations
            1. Quick Styles
          3. Dynamic Interactions
          4. Quick Calculations
          5. Context Calculations
        4. Manage Lite Discoveries
        5. Conversations
      2. Present Lite
        1. Access Present Lite
        2. Present Lite Workspace
          1. Present Lite Actions Menu
          2. Present Lite Design
          3. Present Lite Panels
        3. Build Lite Presentations
          1. Add Content
          2. Miniature Visualizations
          3. New Slicer
          4. Dynamic Text Fields
          5. Import Images
          6. Static Text
          7. Shapes
          8. Interactions
        4. Run Lite Presentations
          1. Slicers
          2. Cross-Filtering and Highlighting
        5. Manage Lite Presentations
      3. Publish Lite
        1. Access Publish Lite
        2. Publish Lite Workspaces
          1. Publish Lite Ribbon
          2. Publish Lite Toolbox
          3. Publish Lite Pages
          4. Publish Lite Canvas
        3. Build Lite Publications
          1. Add Content
          2. Add Slicers
          3. Add Static Text
          4. Dynamic Text
            1. Dynamic Text Fields
            2. Dynamic Placeholders
          5. Table of Contents
          6. Add Static Graphics
          7. Context Menus
          8. Interaction Manager
          9. Themes
          10. Cover Pages
          11. Align and Distribute
          12. Grouping
        4. Manage Lite Publications
          1. Save Lite Publications
          2. Print and Export
          3. Subscriptions
          4. Link Back to Live Content
      4. Tabulate Lite
        1. Accessing Tabulate Lite
          1. Viewing Tabulate Content
          2. How to Enable/Disable Tabulate
        2. Tabulate Lite Workspace
          1. Tabulate Lite Canvas
            1. Zoom in or out of a sheet
          2. Tabulate Lite Ribbons
          3. Tabulate Lite Toolbox
          4. Slicers
          5. Tabulate Status Bar
          6. Tabulate Sheets
          7. Hiding and Showing Sheets
        3. Working with Spreadsheets
          1. Data Entry and Cells
            1. Rows and Columns
            2. Resizing Rows and Columns
            3. Hide and Show Rows and Columns
            4. Freeze Panes
            5. Clipboard
            6. Named Ranges
            7. Working with Formulas
              1. More Formula Details
              2. Formula Bar
              3. Formula Wizard
          2. Formatting
            1. Themes
            2. Cell Formatting
            3. Number Formatting
            4. Tables
            5. Filtering and Sorting
            6. Conditional Formats in Tabulate
              1. Applying Conditional Formats
          3. Using Live Data
            1. Importing Data and Content
              1. Smart Report
              2. Discover Lite
              3. Importing Existing Spreadsheets
            2. Blending Queries
        4. Creating Tabulate Visuals
          1. Drop Zones
          2. Formatting Panels
          3. Panel Layout
        5. Embedding in Present and Publish
        6. Managing Tabulations
          1. Saving Tabulations
          2. Printing and Exporting
          3. Mobile Access
  4. Viewer User
    1. Viewer Workflow Overview
    2. Viewer Home Page
      1. Viewer Home Menu
      2. Viewer System Info
      3. User Hub
    3. Content Management
      1. Content Types
      2. Content Manager
        1. Favorites
        2. Recents
        3. Content Explorer
        4. Most Used
        5. User Recommended
        6. Auto Recommended
        7. Content Search
      3. Schedules and Subscriptions
        1. Publications Board
        2. Alerts Board
        3. Subscriptions Board
        4. Workflow and Conversations Board
        5. Schedule Manager
          1. Alerts Manager
          2. Subscriptions Manager
    4. Interactive Content
      1. Data Discoveries
        1. Discovery Slicers
      2. Presentations
        1. Presentation Slicers
        2. Cross-Visual Interactions
        3. Panel Tools
      3. Viewer Interactions
        1. Conversations
        2. Alerts
        3. Analyze Further
          1. Members Search
    5. Manage Viewer Content
      1. Print and Export
      2. Subscribe to Content
        1. Link Back to Live Content
    6. Mobile and Tablet App
      1. Viewer Mobile Navigation
      2. Open Viewer Content
  5. Basic User
    1. Embed Experience
    2. Embed Hub
    3. Link Back to Live Content
    4. OData Link
  6. Mobile Client
    1. Mobile Phones
      1. Mobile Content Navigation
      2. Open Content
      3. Mobile Presentations
      4. Mobile Interactions
    2. Tablets
      1. App Menu
      2. Thumb Button and Context Menus
      3. Element Tree Navigation
      4. Accessing the Ribbons
      5. Accessing Submenus
      6. Quick Calculations
      7. Tablet Presentations
  7. Natural Language Interfaces
    1. Chatbot and Questions
      1. Access the Chatbot at Design Time
      2. Access the Chatbot at Runtime
      3. Chatbot Functions
        1. Speak to the Chatbot
      4. Writing Natural Language Queries
        1. NLQ: Asking a Basic Question
        2. NLQ: Advanced Intelligence
        3. NLQ: Visualizations
    2. Multiple LLM Engines
      1. Portable Language Model Guidance

Admin Help

  1. Admin Hub
    1. Diagnostic Dashboard
      1. Restarting Services
      2. Disabling Services
      3. In-Memory DB Status
    2. System Usage KPI
  2. Licensing
    1. License Change Wizard
    2. Deactivation of Pyramid
  3. Access
    1. Users
      1. Add Users
      2. Importing Users
      3. Domain Admin Rights
    2. Role Management
      1. Importing Roles
    3. Tenant Management
    4. Profiles
      1. Pro User Profile
      2. Analyst User Profile
      3. Viewer User Profile Settings
    5. User Defaults
    6. Provisioning
  4. Security
    1. Authentication
      1. Multi-Factor Authentication
      2. Active Directory Setup
      3. Azure LDAPS Setup
      4. LDAP Setup
      5. SAML Authentication
        1. Azure SAML Setup
        2. ADFS SAML Setup
      6. OpenID Authentication
    2. Certificate Manager
      1. IMDB Encryption
    3. Server-Side Security
    4. Client Security
  5. Data
    1. Data Sources
      1. Data Source Setups
        1. Data Access with Windows Authentication
        2. Single Sign-on via OAuth
        3. Amazon OAuth Setup
        4. Box Setup
        5. Google OAuth Setup
        6. Microsoft Analysis Services Setup
        7. ODBC Setup
        8. Facebook Setup
        9. FTP Setup
        10. X (Twitter) Setup
        11. SAP BW Setup
        12. SAP HANA Setup
        13. SalesForce Setup
    2. Source Manager
      1. Data Source Servers (Admin)
      2. Database Management (Admin)
        1. Copy or Move a Data Model
      3. Data Model Management (Admin)
        1. Attribute Security
        2. Hierarchy Overlay
        3. Measure Security
        4. Measure Overlay
        5. Level Overlay
        6. Member Security
          1. Dynamic Member Security
          2. Security PQL Script Editor
    3. Pulse Nodes
    4. Kerberos Keytabs
    5. Custom Connectors
    6. Caching
    7. Query Limits
    8. Data Source Limits
    9. Global Settings
  6. Content
    1. Content Settings
    2. Migration Destinations
    3. Webhooks
    4. Custom Workflows
  7. Services
    1. General Settings
    2. Server Instances
      1. Service Memory Limits
    3. Run Time Services
    4. Task Services
    5. Solve Services
    6. Web Services
    7. File System
    8. Message Settings
  8. Schedules
    1. Task Manager
    2. Publication Schedules
    3. Alerts Schedules
    4. Subscriptions Schedules
    5. Models Schedules
    6. Auto Provisioning Jobs
    7. System Schedule
  9. Logs
    1. Entries
    2. Transaction Log
    3. Solve Logs
    4. System Log
    5. Deleted Items Log
    6. Log Settings
      1. Audit Trail Framework
  10. Mobile Devices
    1. Devices
    2. Mobile Devices Settings
  11. Design
    1. App Experience
    2. Themes
      1. Theme Editor
      2. Master Pages
    3. Custom Fonts
    4. Email Templates
      1. Add or Edit Email Template
    5. Hub Templates
      1. Build Hub Templates
      2. Hub Snippet Generator
  12. Geospatial
    1. Custom Maps
    2. Geospatial Settings
  13. AI and DSML
    1. AI Settings
    2. LLM Manager
    3. DSML Settings
    4. DSML Environments

Guides

  1. General Guides
    1. Pyramid Licensing
      1. Solve Access
    2. BI Office Content Conversion
    3. Generative AI Integration
    4. Dynamic Function Wizard
    5. Application Languages
    6. Version History
    7. Older Versions of Help
    8. Other Pyramid Help Resources
  2. Installation Guides
    1. Main Application
      1. System Requirements
      2. Quick Guide for Windows
      3. Quick Guide for Linux
      4. Upgrade Installations
      5. Unattended Installations
      6. Installation Steps
        1. Installation Rights
        2. Installation Directories
        3. Encryption and FIPS
          1. Encrypting Connections
        4. Server Deployment
          1. Adding and Removing Services
        5. Database Repository Installation
        6. Web Server Installation
          1. NGINX Web Server
          2. Create a Pyramid Website
        7. Initialization
        8. Post Installation Adjustments
        9. Offline Installation
          1. Offline Installation of R and Python
        10. Product Activation
          1. Trial Registrations
          2. New Deployment Activation
          3. Offline Registrations
          4. Changing Licensed Servers
      7. Repository Backups
        1. Recovery
    2. Kubernetes
      1. Recommendations for Kubernetes
      2. Kubernetes Initialization
        1. Kubernetes Unattended Initialization
      3. HELM Charts
        1. Unattended Kubernetes Configuration
        2. HELM Configuration
      4. Pyramid on AWS Kubernetes
      5. Pyramid on Azure Kubernetes
      6. Pyramid on GCP Kubernetes
      7. Kubernetes Configurator
    3. Pulse
      1. Pulse Installation Steps
    4. Cloud Server Quick Start
      1. Pyramid Analytics for AWS Marketplace
    5. Client Desktop
    6. System Maintenance Tools
    7. Uninstallation
  3. Configuration Guides
    1. Kerberos Delegation for Pyramid
    2. Amazon Load Balancer
  4. Deployment and Security Guides
    1. Scaling Pyramid
    2. Pyramid Usage
    3. User Deployment in Pyramid
    4. Application Security Overview
    5. Security Hardening Guide
    6. FIPS Compliance
    7. Mobile App Deployment
    8. Creating Accessible Content
  5. SAP Guides
    1. SAP SSO 'SNC' Setup Guide
    2. Support for SAP BW Features
    3. Troubleshooting Guide for SAP BW

Tech Reference

  1. Query & Function Overview
    1. PQL & MDX Language Reference
      1. MDX Language
        1. Semantic Library (MDX)
          1. Date-Time Functions
            1. ClosingPeriod
            2. LastPeriods
            3. MTD
            4. OpeningPeriod
            5. ParallelPeriod
            6. PeriodsToDate
            7. QTD
            8. WTD
            9. YTD
          2. Hierarchical Functions
            1. Ascendants
            2. Children
            3. Cousin
            4. Descendants
            5. Dimension
            6. Dimensions
            7. DrilldownLevel
            8. DrilldownLevelBottom
            9. DrilldownLevelTop
            10. DrilldownMember
            11. DrilldownMemberBottom
            12. DrilldownMemberTop
            13. DrillupLevel
            14. DrillupMember
            15. FirstChild
            16. FirstSibling
            17. Hierarchy
            18. LastChild
            19. LastSibling
            20. Level
            21. Levels
            22. Ordinal
            23. Parent
            24. RollupChildren
            25. Root
            26. Siblings
          3. KPI Functions
            1. KPICurrentTimeMember
            2. KPIGoal
            3. KPIStatus
            4. KPITrend
            5. KPIValue
            6. KPIWeight
          4. List Functions
            1. AddCalculatedMembers
            2. AllMembers
            3. Ancestors
            4. Axis
            5. BottomCount
            6. BottomPercent
            7. BottomSum
            8. Crossjoin
            9. Distinct
            10. Except
            11. Exists
            12. Extract
            13. Filter
            14. Generate
            15. Head
            16. Hierarchize
            17. Intersect
            18. Leaves
            19. MeasureGroupMeasures
            20. Members
            21. NameToSet
            22. NonEmpty
            23. NonEmptyCrossjoin
            24. Order
            25. StripCalculatedMembers
            26. Subset
            27. Tail
            28. ToggleDrillState
            29. TopCount
            30. TopPercent
            31. TopSum
            32. Union
            33. Unorder
          5. Logical Functions
            1. Error
            2. IIf
            3. IsAncestor
            4. IsEmpty
            5. IsGeneration
            6. IsLeaf
            7. IsSibling
          6. Member Functions
            1. Ancestor
            2. Current
            3. CurrentMember
            4. DataMember
            5. DefaultMember
            6. Item
            7. Lag
            8. Lead
            9. LinkMember
            10. NextMember
            11. PrevMember
            12. UnknownMember
          7. Other Functions
            1. CalculationCurrentPass
            2. CalculationPassValue
            3. CoalesceEmpty
            4. CurrentOrdinal
            5. LookupCube
            6. Properties
            7. SetToArray
            8. UserName
            9. ValidMeasure
            10. Value
          8. Statistical Functions
            1. Aggregate
            2. Avg
            3. Correlation
            4. Count
            5. Covariance
            6. CovarianceN
            7. DistinctCount
            8. LinRegIntercept
            9. LinRegPoint
            10. LinRegR2
            11. LinRegSlope
            12. LinRegVariance
            13. Max
            14. Median
            15. Min
            16. Predict
            17. Rank
            18. Stdev
            19. StdevP
            20. Sum
            21. Variance
            22. VarianceP
            23. VisualTotals
          9. String Functions
            1. MemberToStr
            2. Name
            3. SetToStr
            4. StrToMember
            5. StrToSet
            6. StrToTuple
            7. StrToValue
            8. TupleToStr
            9. UniqueName
        2. VBA Library (MDX)
          1. Conversion Functions
            1. CBool
            2. CByte
            3. CCur
            4. CDate
            5. CDbl
            6. CDec
            7. CInt
            8. CLng
            9. CSng
            10. CStr
            11. CVar
            12. TypeName
          2. Date-Time Functions
            1. Date
            2. DateAdd
            3. DateDiff
            4. DatePart
            5. DateSerial
            6. DateValue
            7. Day
            8. Hour
            9. Minute
            10. Month
            11. Now
            12. Second
            13. Timer
            14. TimeSerial
            15. TimeValue
            16. Weekday
            17. Year
          3. Financial Functions
            1. DDB
            2. FV
            3. IPmt
            4. IRR
            5. MIRR
            6. NPer
            7. NPV
            8. Pmt
            9. PPmt
            10. PV
            11. Rate
            12. SLN
            13. SYD
          4. Logical Functions
            1. Choose
            2. Iif
            3. IsArray
            4. IsDate
            5. IsEmpty
            6. IsError
            7. IsMissing
            8. IsNull
            9. IsNumeric
            10. Switch
          5. Math Functions
            1. Abs
            2. Atn
            3. Cos
            4. Exp
            5. Fix
            6. Int
            7. Log
            8. QBColor
            9. RGB
            10. Rnd
            11. Round
            12. Sgn
            13. Sin
            14. Sqr
            15. Tan
          6. String Functions
            1. Asc
            2. Chr
            3. Format
            4. Hex
            5. InStr
            6. LCase
            7. Left
            8. Len
            9. LTrim
            10. Mid
            11. Oct
            12. Partition
            13. Right
            14. RTrim
            15. Space
            16. Str
            17. StrComp
            18. StrConv
            19. String
            20. Trim
            21. UCase
            22. Val
        3. Spreadsheet Library (PQL)
          1. Pyramid Functions
            1. DATA
            2. MEMBER
            3. PARAMETER
            4. SLICER
            5. SLICERCAPTION
          2. Database Functions
            1. DAVERAGE
            2. DCOUNT
            3. DCOUNTA
            4. DGET
            5. DMAX
            6. DMIN
            7. DPRODUCT
            8. DSTDEV
            9. DSTDEVP
            10. DSUM
            11. DVAR
            12. DVARP
          3. Date & Time Functions
            1. DATE
            2. DATEDIF
            3. DATEVALUE
            4. DAY
            5. DAYS
            6. DAYS360
            7. EDATE
            8. EOMONTH
            9. HOUR
            10. ISOWEEKNUM
            11. MINUTE
            12. MONTH
            13. NETWORKDAYS
            14. NETWORKDAYS.INTL
            15. NOW
            16. SECOND
            17. TIME
            18. TIMEVALUE
            19. TODAY
            20. WEEKDAY
            21. WEEKNUM
            22. WORKDAY
            23. WORKDAY.INTL
            24. YEAR
            25. YEARFRAC
          4. Engineering Functions
            1. BESSELI
            2. BESSELJ
            3. BESSELK
            4. BESSELY
            5. BIN2DEC
            6. BIN2HEX
            7. BIN2OCT
            8. BITAND
            9. BITLSHIFT
            10. BITOR
            11. BITRSHIFT
            12. BITXOR
            13. COMPLEX
            14. CONVERT
            15. DEC2BIN
            16. DEC2HEX
            17. DEC2OCT
            18. DELTA
            19. ERF
            20. ERF.PRECISE
            21. ERFC
            22. ERFC.PRECISE
            23. GESTEP
            24. HEX2BIN
            25. HEX2DEC
            26. HEX2OCT
            27. IMABS
            28. IMAGINARY
            29. IMARGUMENT
            30. IMCONJUGATE
            31. IMCOS
            32. IMCOSH
            33. IMCOT
            34. IMCSC
            35. IMCSCH
            36. IMDIV
            37. IMEXP
            38. IMLN
            39. IMLOG10
            40. IMLOG2
            41. IMPOWER
            42. IMPRODUCT
            43. IMREAL
            44. IMSEC
            45. IMSECH
            46. IMSIN
            47. IMSINH
            48. IMSQRT
            49. IMSUB
            50. IMSUM
            51. IMTAN
            52. OCT2BIN
            53. OCT2DEC
            54. OCT2HEX
          5. Financial Functions
            1. ACCRINT
            2. ACCRINTM
            3. AMORDEGRC
            4. AMORLINC
            5. COUPDAYBS
            6. COUPDAYS
            7. COUPDAYSNC
            8. COUPNCD
            9. COUPNUM
            10. COUPPCD
            11. CUMIPMT
            12. CUMPRINC
            13. DB
            14. DDB
            15. DISC
            16. DOLLARDE
            17. DOLLARFR
            18. DURATION
            19. EFFECT
            20. FV
            21. FVSCHEDULE
            22. INTRATE
            23. IPMT
            24. IRR
            25. ISPMT
            26. MDURATION
            27. MIRR
            28. NOMINAL
            29. NPER
            30. NPV
            31. ODDFPRICE
            32. ODDFYIELD
            33. ODDLPRICE
            34. ODDLYIELD
            35. EURO
            36. EUROCONVERT
            37. PDURATION
            38. PMT
            39. PPMT
            40. PRICE
            41. PRICEDISC
            42. PRICEMAT
            43. PV
            44. RATE
            45. RECEIVED
            46. RRI
            47. SLN
            48. SYD
            49. TBILLEQ
            50. TBILLPRICE
            51. TBILLYIELD
            52. VDB
            53. XIRR
            54. XNPV
            55. YIELD
            56. YIELDDISC
            57. YIELDMAT
          6. Information Functions
            1. ERROR.TYPE
            2. ISBLANK
            3. ISERR
            4. ISERROR
            5. ISEVEN
            6. ISFORMULA
            7. ISLOGICAL
            8. ISNA
            9. ISNONTEXT
            10. ISNUMBER
            11. ISODD
            12. ISOMITTED
            13. ISREF
            14. ISTEXT
            15. N
            16. NA
            17. SHEET
            18. SHEETS
            19. TYPE
          7. Logical Functions
            1. AND
            2. BYCOL
            3. BYROW
            4. IF
            5. IFERROR
            6. IFNA
            7. IFS
            8. LAMBDA
            9. LET
            10. MAKEARRAY
            11. MAP
            12. NOT
            13. OR
            14. REDUCE
            15. SCAN
            16. SWITCH
            17. XOR
          8. Lookup Functions
            1. ADDRESS
            2. AREAS
            3. CHOOSE
            4. CHOOSECOLS
            5. CHOOSEROWS
            6. COLUMN
            7. COLUMNS
            8. DROP
            9. EXPEND
            10. FILTER
            11. FORMULATEXT
            12. HLOOKUP
            13. HSTACK
            14. HYPERLINK
            15. INDEX
            16. INDIRECT
            17. LOOKUP
            18. MATCH
            19. OFFSET
            20. ROW
            21. ROWS
            22. SORT
            23. SORTBY
            24. TOCOL
            25. TOROW
            26. TRANSPOSE
            27. UNIQUE
            28. VLOOKUP
            29. VSTACK
            30. WRAPCOLS
            31. WRAPROWS
            32. XLOOKUP
            33. XMATCH
          9. Math & Trig Functions
            1. ABS
            2. ACOS
            3. ACOSH
            4. ACOT
            5. ACOTH
            6. AGGREGATE
            7. ARABIC
            8. ASIN
            9. ASINH
            10. ATAN
            11. ATAN2
            12. ATANH
            13. BASE
            14. CEILING
            15. CEILING.MATH
            16. CEILING.PRECISE
            17. COMBIN
            18. COMBINA
            19. COS
            20. COSH
            21. COT
            22. COTH
            23. CSC
            24. CSCH
            25. DECIMAL
            26. DEGREES
            27. EVEN
            28. EXP
            29. FACT
            30. FACTDOUBLE
            31. FLOOR.MATH
            32. FLOOR.PRECISE
            33. GCD
            34. INT
            35. ISO.CEILING
            36. LCM
            37. LN
            38. LOG
            39. LOG10
            40. MDETERM
            41. MINVERSE
            42. MMULT
            43. MOD
            44. MROUND
            45. MULTINOMIAL
            46. ODD
            47. PI
            48. POWER
            49. PRODUCT
            50. QUOTIENT
            51. RADIANS
            52. RAND
            53. RANDARRAY
            54. RANDBETWEEN
            55. ROMAN
            56. ROUND
            57. ROUNDDOWN
            58. ROUNDUP
            59. SEC
            60. SECH
            61. SEQUENCE
            62. SERIESSUM
            63. SIGN
            64. SIN
            65. SINH
            66. SQRT
            67. SQRTPI
            68. SUBTOTAL
            69. SUM
            70. SUMIF
            71. SUMIFS
            72. SUMPRODUCT
            73. SUMSQ
            74. SUMX2MY2
            75. SUMX2PY2
            76. SUMXMY2
            77. TAN
            78. TANH
            79. TRUNC
          10. Statistical Functions
            1. AVEDEV
            2. AVERAGE
            3. AVERAGEA
            4. AVERAGEIF
            5. AVERAGEIFS
            6. BETA.DIST
            7. BETA.INV
            8. BINOM.DIST
            9. BINOM.DIST.RANGE
            10. BINOM.INV
            11. CHISQ.DIST
            12. CHISQ.DIST.RT
            13. CHISQ.INV
            14. CHISQ.INV.RT
            15. CHISQ.TEST
            16. CONFIDENCE.NORM
            17. CONFIDENCE.T
            18. CORREL
            19. COUNT
            20. COUNTA
            21. COUNTBLANK
            22. COUNTIF
            23. COUNTIFS
            24. COVARIANCE.P
            25. COVARIANCE.S
            26. DEVSQ
            27. EXPON.DIST
            28. F.DIST
            29. F.DIST.RT
            30. F.INV
            31. F.INV.RT
            32. F.TEST
            33. FINV
            34. FISHER
            35. FISHERINV
            36. FORECAST
            37. FREQUENCY
            38. GAMMA
            39. GAMMA.DIST
            40. GAMMA.INV
            41. GAMMALN
            42. GAMMALN.PRECISE
            43. GAUSS
            44. GEOMEAN
            45. GROWTH
            46. HARMEAN
            47. HYPGEOM.DIST
            48. INTERCEPT
            49. KURT
            50. LARGE
            51. LINEST
            52. LOGEST
            53. LOGNORM.DIST
            54. LOGNORM.INV
            55. MAX
            56. MAXA
            57. MAXIFS
            58. MEDIAN
            59. MIN
            60. MINA
            61. MINIFS
            62. MODE.MULT
            63. MODE.SNGL
            64. NEGBINOM.DIST
            65. NORM.DIST
            66. NORM.INV
            67. NORM.S.DIST
            68. NORM.S.INV
            69. PEARSON
            70. PERCENTILE.EXC
            71. PERCENTILE.INC
            72. PERCENTRANK.EXC
            73. PERCENTRANK.INC
            74. PERMUT
            75. PERMUTATIONA
            76. PHI
            77. POISSON.DIST
            78. PROB
            79. QUARTILE.EXC
            80. QUARTILE.INC
            81. RANK.AVG
            82. RANK.EQ
            83. RSQ
            84. SKEW
            85. SKEW.P
            86. SLOPE
            87. SMALL
            88. STANDARDIZE
            89. STDEV.P
            90. STDEV.S
            91. STDEVA
            92. STDEVPA
            93. STEYX
            94. T.DIST
            95. T.DIST.2T
            96. T.DIST.RT
            97. T.INV
            98. T.INV.2T
            99. T.TEST
            100. TREND
            101. TRIMMEAN
            102. VAR.P
            103. VAR.S
            104. VARA
            105. VARPA
            106. WEIBULL.DIST
            107. Z.TEST
          11. Text Functions
            1. ASC
            2. BAHTTEXT
            3. CHAR
            4. CLEAN
            5. CODE
            6. CONCAT
            7. CONCATENATE
            8. DBCS
            9. DOLLAR
            10. EXACT
            11. FIND
            12. FIXED
            13. LEFT
            14. LEN
            15. LOWER
            16. MID
            17. OBJECT
            18. PROPER
            19. REPLACE
            20. REPT
            21. RIGHT
            22. SEARCH
            23. SEARCHB
            24. SUBSTITUTE
            25. T
            26. TEXT
            27. TEXTAFTER
            28. TEXTBEFORE
            29. TEXTJOIN
            30. TEXTSPLIT
            31. TRIM
            32. UNICHAR
            33. UNICODE
            34. UPPER
            35. VALUE
          12. Web Functions
            1. ENCODEURL
            2. FILTERJSON
            3. WEBSERVICE
          13. Compatibility Functions
            1. BETADIST
            2. BETAINV
            3. BINOMDIST
            4. CHIDIST
            5. CHIINV
            6. CHITEST
            7. CONFIDENCE
            8. COVAR
            9. CRITBINOM
            10. EXPONDIST
            11. FDIST
            12. FLOOR
            13. FTEST
            14. GAMMADIST
            15. GAMMAINV
            16. HYPGEOMDIST
            17. LOGINV
            18. LOGNORMDIST
            19. MODE
            20. NEGBINOMDIST
            21. NORMDIST
            22. NORMINV
            23. NORMSDIST
            24. NORMSINV
            25. PERCENTILE
            26. PERCENTRANK
            27. POISSON
            28. QUARTILE
            29. RANK
            30. STDEV
            31. STDEVP
            32. TDIST
            33. TINV
            34. TTEST
            35. VAR
            36. VARP
            37. WEIBULL
            38. ZTEST
    2. PQL Language
      1. Action Library (PQL)
        1. Cross-Model Functions
          1. DimensionCaption
          2. DimensionUniqueName
          3. HierarchyCaption
          4. HierarchyUniqueName
          5. MemberCaption
          6. MemberKey
          7. MemberUniqueName
          8. SourceMember
          9. TargetMember
        2. Jump Functions
          1. Captions
          2. CellValue
          3. ItemExists
          4. UniqueNames
      2. Common Library (PQL)
        1. Date-Time Functions
          1. AddDays
          2. AddHours
          3. AddMinutes
          4. AddMonths
          5. AddQuarters
          6. AddWeeks
          7. AddYears
          8. CreateDate
          9. Date
          10. DateDiff
          11. DateFormat
          12. DateTime
          13. DateToTimeStamp
          14. DayNumber
          15. Hour
          16. Minute
          17. Month
          18. MonthNumber
          19. Quarter
          20. QuarterNumber
          21. Second
          22. StringToDate
          23. StringtoDateTime
          24. TimeStampToDate
          25. Week
          26. WeekNumber
          27. Year
        2. Formats Functions
          1. AutoFormat
          2. CurrencyDollars0
          3. CurrencyDollars2
          4. CurrencyEuros0
          5. CurrencyEuros2
          6. CurrencyPounds0
          7. CurrencyPounds2
          8. CurrencyRands0
          9. CurrencyRands2
          10. CurrencyShekels0
          11. CurrencyShekels2
          12. CurrencySwissFrancs0
          13. CurrencySwissFrancs2
          14. DateAmerican
          15. DateTimeAmerican
          16. DateTimeUniversal
          17. DateTimeWestern
          18. DateUniversal
          19. DateWestern
          20. Number0
          21. Number1
          22. Number2
          23. NumberBillions
          24. NumberMillions
          25. NumberThousands
          26. Percent0
          27. Percent1
          28. Percent2
        3. Geo Functions
          1. GeoDistance
        4. Identity Functions
          1. ApplicationCulture
          2. UserAdAccount
          3. UserAdDomain
          4. UserCustomData
          5. UserEmail
          6. UserFirstName
          7. UserLastName
          8. UserName
          9. UserPrincipalName
          10. UserPrincipalNameAlt
          11. UserProxyAccount
          12. UserProxyAccount2
          13. UserRoles
          14. UserRolesSet
          15. UserTenant
        5. Logical Functions
          1. Case
          2. Equals
          3. If
          4. IfNull
          5. IsNAN
          6. Loop
          7. LoopVector
          8. NotEquals
          9. Switch
        6. Math Functions
          1. Absolute
          2. ArcCos
          3. ArcSin
          4. ArcTan
          5. Ceiling
          6. Coalesce
          7. ConvertToNumber
          8. Cos
          9. Ctan
          10. Divide
          11. E
          12. Exponent
          13. Floor
          14. Ln
          15. Log
          16. Log10
          17. Log2
          18. Multiply
          19. PI
          20. Power
          21. Random
          22. RandomDouble
          23. RemoveBlanks
          24. RGB
          25. Round
          26. Sin
          27. Tan
          28. ToDegrees
          29. ToRadians
        7. Statistical Functions
          1. Average
          2. Correlation
          3. Covariance
          4. DataSet
          5. IndexOfMax
          6. IndexOfMin
          7. Maximum
          8. Median
          9. Minimum
          10. PercentileRank
          11. Rank
          12. StandardDeviation
          13. Sum
        8. String Functions
          1. Contains
          2. EndsWith
          3. FindByPattern
          4. Format
          5. HasItem
          6. IndexOf
          7. Left
          8. Length
          9. LLM
          10. Replace
          11. Right
          12. StartsWith
          13. StringJoin
          14. SubString
          15. ToLower
          16. ToProper
          17. ToString
          18. ToUpper
          19. Trim
          20. TrimLeft
          21. TrimRight
          22. UrlDecode
          23. UrlEncode
      3. Dynamic Library (PQL)
        1. Column Functions
          1. DataSetColumn
          2. DataSetColumnRange
          3. FindColumnNumber
          4. LastColumn
          5. LookupMaxColumn
          6. LookupMinColumn
          7. NumberOfColumns
          8. TotalColumn
        2. Grid Functions
          1. CountAvg
          2. CountPercentile
          3. Data
          4. Forecast
          5. ForecastPercent
          6. ForecastValue
          7. FormattedData
          8. GridCountAvg
          9. GridCountPercentile
          10. IsCellEmpty
          11. IsCellValid
          12. IsEmptyQuery
          13. IsQueryValid
          14. Label
          15. LinearTrendSlopeValue
          16. MaxGrid
          17. MinGrid
          18. NumberOfCells
          19. Outlier
          20. TotalGrid
        3. Markup Functions
          1. Bold
          2. Bullet
          3. FontFormat
          4. HyperLink
          5. Image
          6. Italics
          7. LineBreak
          8. OrderedList
          9. Underline
          10. UnorderedList
        4. Row Functions
          1. DataSetRow
          2. DataSetRowRange
          3. FindRowNumber
          4. LastRow
          5. LookupMaxRow
          6. LookupMinRow
          7. NumberOfRows
          8. TotalRow
        5. Smart Functions
          1. SmartInsights
          2. SmartInsightsCategorical
      4. Granular Library (PQL)
        1. Date-Time Functions
          1. AddDays
          2. AddHours
          3. AddMinutes
          4. AddMonths
          5. AddQuarters
          6. AddWeeks
          7. AddYears
          8. Age
          9. Date
          10. DateDiff
          11. DateFormat
          12. DayNumber
          13. Hour
          14. Minute
          15. Month
          16. MonthName
          17. MonthNumber
          18. Now
          19. Quarter
          20. QuarterNumber
          21. Second
          22. Today
          23. Week
          24. WeekNumber
          25. Year
        2. Identity Functions
          1. UserAdAccount
          2. UserAdDomain
          3. UserCustomData
          4. UserEmail
          5. UserFirstName
          6. UserLastName
          7. UserName
          8. UserPrincipalName
          9. UserPrincipalNameAlt
          10. UserProxyAccount
          11. UserProxyAccount2
          12. UserRoles
          13. UserTenant
        3. Logical Functions
          1. Case
          2. If
          3. IsNull
          4. Not
          5. NullIfEqual
          6. Switch
        4. Math Functions
          1. Abs
          2. ArcCos
          3. ArcSin
          4. ArcTan
          5. Bin
          6. Ceiling
          7. Coalesce
          8. Cos
          9. Ctan
          10. E
          11. Exp
          12. Floor
          13. Log
          14. Log10
          15. Mod
          16. PI
          17. Power
          18. Random
          19. Round
          20. Sin
          21. Sqrt
          22. Tan
          23. ToDecimal
          24. ToDegrees
          25. ToInteger
          26. ToRadians
        5. String Functions
          1. Concat
          2. Contains
          3. EndsWith
          4. IndexOf
          5. Left
          6. Length
          7. Replace
          8. Right
          9. StartsWith
          10. SubString
          11. ToLower
          12. ToString
          13. ToUpper
          14. WordCount
      5. Semantic Library (PQL)
        1. Aggregate Functions
          1. Average
          2. Count
          3. CumulativeTimeSum
          4. DistinctCount
          5. FirstChild
          6. FirstQuartile
          7. LastChild
          8. Maximum
          9. Median
          10. Minimum
          11. Sum
          12. Text
          13. ThirdQuartile
        2. Date-Time Functions
          1. AddDays
          2. AddMonths
          3. AddQuarters
          4. AddWeeks
          5. AddYears
          6. ClosingPeriod
          7. CreateDate
          8. CurrentPeriod
          9. FullMonth
          10. FullQuarter
          11. FullWeek
          12. Fullyear
          13. MTD
          14. OpeningPeriod
          15. ParallelPeriod
          16. ParallelPeriods
          17. QTD
          18. WTD
          19. YTD
        3. Hierarchical Functions
          1. AllDescendants
          2. Ancestor
          3. Ascendants
          4. Children
          5. Cousin
          6. Descendants
          7. FirstChild
          8. FirstSibling
          9. GrandParent
          10. IsAncestor
          11. IsLeaf
          12. IsSibling
          13. LastChild
          14. LastSibling
          15. LeafDescendants
          16. Level
          17. Levels
          18. Ordinal
          19. Parent
          20. Siblings
        4. List Functions
          1. AllMembers
          2. BottomCount
          3. BottomPercent
          4. BottomSum
          5. Except
          6. Filter
          7. Head
          8. Intersect
          9. Leaves
          10. NonEmpty
          11. Not
          12. Order
          13. Range
          14. Subset
          15. Tail
          16. TopCount
          17. TopPercent
          18. TopSum
          19. Union
        5. Logical Functions
          1. HasChildren
          2. HasDataPoint
          3. HasDataPoints
          4. If
          5. ListContainsAll
          6. ListContainsAny
          7. Switch
        6. Member Functions
          1. ClosingElement
          2. CurrentMember
          3. DefaultMember
          4. FirstElement
          5. GetElement
          6. Lag
          7. LastElement
          8. Lead
          9. NextMember
          10. Offset
          11. OpeningElement
          12. PrevMember
        7. Statistical Functions
          1. Aggregate
          2. Average
          3. Correlation
          4. Count
          5. Covariance
          6. CovarianceP
          7. ExpRegA
          8. ExpRegB
          9. ExpRegPoint
          10. ExpRegR2
          11. LinRegIntercept
          12. LinRegPoint
          13. LinRegR2
          14. LinRegSlope
          15. LogRegA
          16. LogRegB
          17. LogRegPoint
          18. LogRegR2
          19. Maximum
          20. Median
          21. Minimum
          22. Multiply
          23. Percentile
          24. PowerRegA
          25. PowerRegB
          26. PowerRegPoint
          27. PowerRegR2
          28. Rank
          29. Stdev
          30. StdevP
          31. Sum
          32. Variance
          33. VarianceP
        8. String Functions
          1. Caption
          2. Contains
          3. EndsWith
          4. Equals
          5. ModelCulture
          6. StartsWith
          7. StrToDate
          8. StrToMember
          9. StrToSet
          10. UniqueName
      6. Spreadsheet Library (PQL)
        1. Pyramid Functions
          1. DATA
          2. MEMBER
          3. PARAMETER
          4. SLICER
          5. SLICERCAPTION
        2. Database Functions
          1. DAVERAGE
          2. DCOUNT
          3. DCOUNTA
          4. DGET
          5. DMAX
          6. DMIN
          7. DPRODUCT
          8. DSTDEV
          9. DSTDEVP
          10. DSUM
          11. DVAR
          12. DVARP
        3. Date & Time Functions
          1. DATE
          2. DATEDIF
          3. DATEVALUE
          4. DAY
          5. DAYS
          6. DAYS360
          7. EDATE
          8. EOMONTH
          9. HOUR
          10. ISOWEEKNUM
          11. MINUTE
          12. MONTH
          13. NETWORKDAYS
          14. NETWORKDAYS.INTL
          15. NOW
          16. SECOND
          17. TIME
          18. TIMEVALUE
          19. TODAY
          20. WEEKDAY
          21. WEEKNUM
          22. WORKDAY
          23. WORKDAY.INTL
          24. YEAR
          25. YEARFRAC
        4. Engineering Functions
          1. BESSELI
          2. BESSELJ
          3. BESSELK
          4. BESSELY
          5. BIN2DEC
          6. BIN2HEX
          7. BIN2OCT
          8. BITAND
          9. BITLSHIFT
          10. BITOR
          11. BITRSHIFT
          12. BITXOR
          13. COMPLEX
          14. CONVERT
          15. DEC2BIN
          16. DEC2HEX
          17. DEC2OCT
          18. DELTA
          19. ERF
          20. ERF.PRECISE
          21. ERFC
          22. ERFC.PRECISE
          23. GESTEP
          24. HEX2BIN
          25. HEX2DEC
          26. HEX2OCT
          27. IMABS
          28. IMAGINARY
          29. IMARGUMENT
          30. IMCONJUGATE
          31. IMCOS
          32. IMCOSH
          33. IMCOT
          34. IMCSC
          35. IMCSCH
          36. IMDIV
          37. IMEXP
          38. IMLN
          39. IMLOG10
          40. IMLOG2
          41. IMPOWER
          42. IMPRODUCT
          43. IMREAL
          44. IMSEC
          45. IMSECH
          46. IMSIN
          47. IMSINH
          48. IMSQRT
          49. IMSUB
          50. IMSUM
          51. IMTAN
          52. OCT2BIN
          53. OCT2DEC
          54. OCT2HEX
        5. Financial Functions
          1. ACCRINT
          2. ACCRINTM
          3. AMORDEGRC
          4. AMORLINC
          5. COUPDAYBS
          6. COUPDAYS
          7. COUPDAYSNC
          8. COUPNCD
          9. COUPNUM
          10. COUPPCD
          11. CUMIPMT
          12. CUMPRINC
          13. DB
          14. DDB
          15. DISC
          16. DOLLARDE
          17. DOLLARFR
          18. DURATION
          19. EFFECT
          20. FV
          21. FVSCHEDULE
          22. INTRATE
          23. IPMT
          24. IRR
          25. ISPMT
          26. MDURATION
          27. MIRR
          28. NOMINAL
          29. NPER
          30. NPV
          31. ODDFPRICE
          32. ODDFYIELD
          33. ODDLPRICE
          34. ODDLYIELD
          35. EURO
          36. EUROCONVERT
          37. PDURATION
          38. PMT
          39. PPMT
          40. PRICE
          41. PRICEDISC
          42. PRICEMAT
          43. PV
          44. RATE
          45. RECEIVED
          46. RRI
          47. SLN
          48. SYD
          49. TBILLEQ
          50. TBILLPRICE
          51. TBILLYIELD
          52. VDB
          53. XIRR
          54. XNPV
          55. YIELD
          56. YIELDDISC
          57. YIELDMAT
        6. Information Functions
          1. ERROR.TYPE
          2. ISBLANK
          3. ISERR
          4. ISERROR
          5. ISEVEN
          6. ISFORMULA
          7. ISLOGICAL
          8. ISNA
          9. ISNONTEXT
          10. ISNUMBER
          11. ISODD
          12. ISOMITTED
          13. ISREF
          14. ISTEXT
          15. N
          16. NA
          17. SHEET
          18. SHEETS
          19. TYPE
        7. Logical Functions
          1. AND
          2. BYCOL
          3. BYROW
          4. IF
          5. IFERROR
          6. IFNA
          7. IFS
          8. LAMBDA
          9. LET
          10. MAKEARRAY
          11. MAP
          12. NOT
          13. OR
          14. REDUCE
          15. SCAN
          16. SWITCH
          17. XOR
        8. Lookup Functions
          1. ADDRESS
          2. AREAS
          3. CHOOSE
          4. CHOOSECOLS
          5. CHOOSEROWS
          6. COLUMN
          7. COLUMNS
          8. DROP
          9. EXPEND
          10. FILTER
          11. FORMULATEXT
          12. HLOOKUP
          13. HSTACK
          14. HYPERLINK
          15. INDEX
          16. INDIRECT
          17. LOOKUP
          18. MATCH
          19. OFFSET
          20. ROW
          21. ROWS
          22. SORT
          23. SORTBY
          24. TOCOL
          25. TOROW
          26. TRANSPOSE
          27. UNIQUE
          28. VLOOKUP
          29. VSTACK
          30. WRAPCOLS
          31. WRAPROWS
          32. XLOOKUP
          33. XMATCH
        9. Math & Trig Functions
          1. ABS
          2. ACOS
          3. ACOSH
          4. ACOT
          5. ACOTH
          6. AGGREGATE
          7. ARABIC
          8. ASIN
          9. ASINH
          10. ATAN
          11. ATAN2
          12. ATANH
          13. BASE
          14. CEILING
          15. CEILING.MATH
          16. CEILING.PRECISE
          17. COMBIN
          18. COMBINA
          19. COS
          20. COSH
          21. COT
          22. COTH
          23. CSC
          24. CSCH
          25. DECIMAL
          26. DEGREES
          27. EVEN
          28. EXP
          29. FACT
          30. FACTDOUBLE
          31. FLOOR.MATH
          32. FLOOR.PRECISE
          33. GCD
          34. INT
          35. ISO.CEILING
          36. LCM
          37. LN
          38. LOG
          39. LOG10
          40. MDETERM
          41. MINVERSE
          42. MMULT
          43. MOD
          44. MROUND
          45. MULTINOMIAL
          46. ODD
          47. PI
          48. POWER
          49. PRODUCT
          50. QUOTIENT
          51. RADIANS
          52. RAND
          53. RANDARRAY
          54. RANDBETWEEN
          55. ROMAN
          56. ROUND
          57. ROUNDDOWN
          58. ROUNDUP
          59. SEC
          60. SECH
          61. SEQUENCE
          62. SERIESSUM
          63. SIGN
          64. SIN
          65. SINH
          66. SQRT
          67. SQRTPI
          68. SUBTOTAL
          69. SUM
          70. SUMIF
          71. SUMIFS
          72. SUMPRODUCT
          73. SUMSQ
          74. SUMX2MY2
          75. SUMX2PY2
          76. SUMXMY2
          77. TAN
          78. TANH
          79. TRUNC
        10. Statistical Functions
          1. AVEDEV
          2. AVERAGE
          3. AVERAGEA
          4. AVERAGEIF
          5. AVERAGEIFS
          6. BETA.DIST
          7. BETA.INV
          8. BINOM.DIST
          9. BINOM.DIST.RANGE
          10. BINOM.INV
          11. CHISQ.DIST
          12. CHISQ.DIST.RT
          13. CHISQ.INV
          14. CHISQ.INV.RT
          15. CHISQ.TEST
          16. CONFIDENCE.NORM
          17. CONFIDENCE.T
          18. CORREL
          19. COUNT
          20. COUNTA
          21. COUNTBLANK
          22. COUNTIF
          23. COUNTIFS
          24. COVARIANCE.P
          25. COVARIANCE.S
          26. DEVSQ
          27. EXPON.DIST
          28. F.DIST
          29. F.DIST.RT
          30. F.INV
          31. F.INV.RT
          32. F.TEST
          33. FINV
          34. FISHER
          35. FISHERINV
          36. FORECAST
          37. FREQUENCY
          38. GAMMA
          39. GAMMA.DIST
          40. GAMMA.INV
          41. GAMMALN
          42. GAMMALN.PRECISE
          43. GAUSS
          44. GEOMEAN
          45. GROWTH
          46. HARMEAN
          47. HYPGEOM.DIST
          48. INTERCEPT
          49. KURT
          50. LARGE
          51. LINEST
          52. LOGEST
          53. LOGNORM.DIST
          54. LOGNORM.INV
          55. MAX
          56. MAXA
          57. MAXIFS
          58. MEDIAN
          59. MIN
          60. MINA
          61. MINIFS
          62. MODE.MULT
          63. MODE.SNGL
          64. NEGBINOM.DIST
          65. NORM.DIST
          66. NORM.INV
          67. NORM.S.DIST
          68. NORM.S.INV
          69. PEARSON
          70. PERCENTILE.EXC
          71. PERCENTILE.INC
          72. PERCENTRANK.EXC
          73. PERCENTRANK.INC
          74. PERMUT
          75. PERMUTATIONA
          76. PHI
          77. POISSON.DIST
          78. PROB
          79. QUARTILE.EXC
          80. QUARTILE.INC
          81. RANK.AVG
          82. RANK.EQ
          83. RSQ
          84. SKEW
          85. SKEW.P
          86. SLOPE
          87. SMALL
          88. STANDARDIZE
          89. STDEV.P
          90. STDEV.S
          91. STDEVA
          92. STDEVPA
          93. STEYX
          94. T.DIST
          95. T.DIST.2T
          96. T.DIST.RT
          97. T.INV
          98. T.INV.2T
          99. T.TEST
          100. TREND
          101. TRIMMEAN
          102. VAR.P
          103. VAR.S
          104. VARA
          105. VARPA
          106. WEIBULL.DIST
          107. Z.TEST
        11. Text Functions
          1. ASC
          2. BAHTTEXT
          3. CHAR
          4. CLEAN
          5. CODE
          6. CONCAT
          7. CONCATENATE
          8. DBCS
          9. DOLLAR
          10. EXACT
          11. FIND
          12. FIXED
          13. LEFT
          14. LEN
          15. LOWER
          16. MID
          17. OBJECT
          18. PROPER
          19. REPLACE
          20. REPT
          21. RIGHT
          22. SEARCH
          23. SEARCHB
          24. SUBSTITUTE
          25. T
          26. TEXT
          27. TEXTAFTER
          28. TEXTBEFORE
          29. TEXTJOIN
          30. TEXTSPLIT
          31. TRIM
          32. UNICHAR
          33. UNICODE
          34. UPPER
          35. VALUE
        12. Web Functions
          1. ENCODEURL
          2. FILTERJSON
          3. WEBSERVICE
        13. Compatibility Functions
          1. BETADIST
          2. BETAINV
          3. BINOMDIST
          4. CHIDIST
          5. CHIINV
          6. CHITEST
          7. CONFIDENCE
          8. COVAR
          9. CRITBINOM
          10. EXPONDIST
          11. FDIST
          12. FLOOR
          13. FTEST
          14. GAMMADIST
          15. GAMMAINV
          16. HYPGEOMDIST
          17. LOGINV
          18. LOGNORMDIST
          19. MODE
          20. NEGBINOMDIST
          21. NORMDIST
          22. NORMINV
          23. NORMSDIST
          24. NORMSINV
          25. PERCENTILE
          26. PERCENTRANK
          27. POISSON
          28. QUARTILE
          29. RANK
          30. STDEV
          31. STDEVP
          32. TDIST
          33. TINV
          34. TTEST
          35. VAR
          36. VARP
          37. WEIBULL
          38. ZTEST
      7. Context Library (PQL)
    3. Function Elements and Syntax
      1. Function Arguments
      2. Function Return Values
      3. Operators
        1. Arithmetic Operators
        2. Comparison Operators
        3. Logical Operators
      4. Data Object Syntax
        1. Dimensions and Tables
        2. Hierarchies and Columns
        3. Members and Elements
        4. Values and Measures
        5. Data Points or Tuples
        6. Lists and Sets
        7. SelfCalc
    4. Script Editors
      1. PQL Editor
  2. Extensibility
    1. Embedding
      1. Embed Flows
      2. Embed Authentication
      3. Embed Code Examples
      4. Embed Troubleshooting
      5. Embed API
        1. Embed API Objects
        2. PyramidEmbedClient
          1. Login
          2. LoginWindowsAuth
          3. LoginSamlAuth
          4. LoginOpenIdAuth
          5. Authentication Failure Callback
          6. Init
          7. Embed
          8. Hub
          9. QuickEmbed
          10. SetAuthToken
          11. GetAuthToken
          12. Host
          13. IsClientLoaded
          14. IsLoggedIn
          15. Content Embedding
            1. EmbedOptions
              1. QuickEmbedOptions
              2. Export Types
            2. Filter
              1. Add (filters)
              2. AddUniqueName (filters)
            3. Target
              1. Add (targets)
            4. EmbeddedResult
              1. GoToSlide
              2. EmbeddedType
              3. Query
              4. Hierarchy
              5. Member
          16. Hub Embedding
            1. Hub (Object)
              1. HubEmbedOptions
                1. Style
      6. Raw API (Embed API v1.0)
        1. Using Raw API
        2. Raw Code Embedding
    2. Direct Load (via URL)
      1. URL Parameterization
    3. External Parameterization
      1. Target Parameterization for Presentations
    4. Direct Launch (via URL)
  3. APIs
    1. Main API and SDKs
      1. Using REST
      2. Using SDKs
      3. REST API HTTP Status Codes
      4. Authentication APIs Overview
      5. API 3.0 Methods
        1. Access APIs
          1. addAnalystProfile
          2. addDomainSettings
          3. addProProfile
          4. addScientistProfile
          5. addUserToRole
          6. addUsersToRole
          7. addViewerProfile
          8. changeRoleAdGroups
          9. changeUserLicense
          10. createRole
          11. createRoles
          12. createTenant
          13. createTenants
          14. createUserAd
          15. createUserDb
          16. createUserOpenId
          17. createUserSaml
          18. createUsersAd
          19. createUsersDb
          20. createUsersOpenId
          21. createUsersSaml
          22. deleteProfile
          23. deleteRole
          24. deleteTenants
          25. deleteUser
          26. findRoles
          27. getAllProfiles
          28. getAllRoles
          29. getAllTenants
          30. getDefaultTenant
          31. getGroupsByRole
          32. getLicenseCount
          33. getLicenseExpirationDate
          34. getLicenseValidationStatus
          35. getMe
          36. getProfileForUser
          37. getProfilesByTenant
          38. getProfilesByUserType
          39. getPublicRoles
          40. getPublicRolesByTenant
          41. getRoleById
          42. getRolesByUser
          43. getRolesbyProfile
          44. getTenantByName
          45. getTenantProfilesByUserType
          46. getTenantUnusedLicenseCount
          47. getTenantUsersByUserType
          48. getUser
          49. getUserByOpenIdPrincipalName
          50. getUserBySamlPrincipalName
          51. getUserLastLogin
          52. getUserStatusById
          53. getUserStatusByName
          54. getUsersByCurrentTenant
          55. getUsersByName
          56. getUsersByRole
          57. getUsersByTenant
          58. searchAdGroups
          59. searchAdGroupsForUser
          60. searchAdUsers
          61. searchAdUsersForGroups
          62. setUserAdministrationLevel
          63. toggleUserStatus
          64. updateDomainAdminPermissions
          65. updateRoleProfiles
          66. updateTenant
          67. updateTenantSeats
          68. updateUserAd
          69. updateUserDb
          70. updateUserOpenId
          71. updateUserRoles
          72. updateUserSaml
          73. updateUsersAd
          74. updateUsersDb
          75. updateUsersOpenId
          76. updateUsersPhones
          77. updateUsersSaml
        2. Analytics APIs
          1. createDiscover
          2. extractNlpQueryResult
          3. extractQueryResult
          4. getFormula
          5. getList
          6. getParameterElements
          7. setFormula
          8. setList
        3. Authentication APIs
          1. authenticateUser
          2. authenticateUserByToken
          3. authenticateUserEmbed
          4. authenticateUserEmbedByToken
          5. authenticateUserEmbedOPENID
          6. authenticateUserEmbedSAML
          7. authenticateUserEmbedWindows
          8. authenticateUserOPENID
          9. authenticateUserSAML
          10. authenticateUserSAMLAlt
          11. authenticateUserWindows
        4. Content APIs
          1. addItemsToFavorites
          2. addRoleToItem
          3. addTag
          4. addTagToItem
          5. changeItemDescription
          6. changeItemFolder
          7. copyItems
          8. createNewFolder
          9. deleteItems
          10. deleteTag
          11. exportContent
          12. exportHub
          13. findContentItem
          14. findItemsByTag
          15. findItemsByTagName
          16. getAllItemTags
          17. getAllItemsCreatedByUser
          18. getAllTags
          19. getAllTagsData
          20. getAutoRecommendedItems
          21. getContentItemMetaData
          22. getFavoriteItems
          23. getFolderItems
          24. getItem
          25. getItemRoles
          26. getItemRolesID
          27. getMostUsedItems
          28. getPrivateFolderForUser
          29. getRecentItems
          30. getRecommendedItems
          31. getTagData
          32. getTenantPublicOrGroupFolder
          33. getUserGroupFolders
          34. getUserGroupRootFolder
          35. getUserPrivateFolder
          36. getUserPrivateRootFolder
          37. getUserPublicFolders
          38. getUserPublicRootFolder
          39. importContent
          40. importHub
          41. moveItems
          42. purgeContentItems
          43. removeItemsFromFavorites
          44. removeRolesFromItem
          45. removeTagFromItem
          46. renameItem
          47. restoreDeletedItems
        5. Datasources APIs
          1. addHierarchyOverlay
          2. addHierarchySecurity
          3. addMeasureOverlay
          4. addMeasureSecurity
          5. addMembersSecurity
          6. addRolesToDataBase
          7. addRolesToItemAndBubbleUp
          8. addRolesToItemAndPropagate
          9. addRolesToModel
          10. addRolesToServer
          11. changeDataSource
          12. changeDataSources
          13. createDataServer
          14. createDataServers
          15. deleteDataBase
          16. deleteDataSource
          17. deleteHierarchyOverlay
          18. deleteHierarchySecurity
          19. deleteMaterializedModel
          20. deleteMeasureOverlay
          21. deleteMeasureSecurity
          22. deleteMembersSecurity
          23. deleteRolesFromDatabase
          24. deleteRolesFromModel
          25. deleteRolesFromServer
          26. executeMasterFlow
          27. exportDataCatalog
          28. exportModel
          29. findDatabaseByName
          30. findServerByName
          31. getAllConnectionStrings
          32. getDataModelStructure
          33. getDataServerDetails
          34. getDataSourcesByTenant
          35. getDataSourcesByUserId
          36. getDatasourceUsedTables
          37. getHierarchyOverlay
          38. getHierarchySecurity
          39. getItemConnectionString
          40. getMasterFlowProgressUpdate
          41. getMasterFlowVariables
          42. getMeasureOverlay
          43. getMeasureSecurity
          44. getMemberSecurity
          45. getModelStructure
          46. getPulseNodesForTenant
          47. getRolesByDataBase
          48. getRolesByModel
          49. getRolesByServer
          50. getSourceByNode
          51. getTargetByNode
          52. getUserDataCatalog
          53. importModel
          54. recognizeDataBase
          55. recognizeModel
          56. searchConnectionString
          57. updateDataCatalog
          58. updateDataFlowNodeSchemas
          59. updateModelName
          60. updateModelProcessDate
          61. updateSourceNodeConnection
          62. updateTargetNodeConnection
          63. updateVariableConnection
          64. updateVariableValue
          65. validateMasterFlow
        6. Notification APIs
          1. getNotificationIndicators
        7. Tasks APIs
          1. deleteSchedule
          2. deleteSchedules
          3. findSchedule
          4. getExecutions
          5. getScheduleExecutionStatus
          6. getSchedulesForUser
          7. getTaskData
          8. getTaskOutputs
          9. getTaskOutputsForUser
          10. getTasks
          11. getTasksIds
          12. reRunTask
          13. resumeSchedule
          14. runOnDemandSchedules
          15. runSchedule
          16. suspendSchedule
        8. Themes APIs
          1. applyTheme
          2. exportTheme
          3. findThemeByName
          4. importTheme
      6. API 2.0 Methods
        1. Access APIs
          1. addAnalystProfile
          2. addDomainSettings
          3. addProProfile
          4. addProfile
          5. addScientistProfile
          6. addUserToRole
          7. addUsersToRole
          8. addViewerProfile
          9. changeLicenseForUser
          10. changeRoleAdGroupMembership
          11. createRole
          12. createRoles
          13. createTenant
          14. createTenants
          15. createUserAd
          16. createUserDb
          17. createUserOpenId
          18. createUserSaml
          19. createUsersAd
          20. createUsersDb
          21. createUsersOpenId
          22. createUsersSaml
          23. deleteProfile
          24. deleteRole
          25. deleteTenants
          26. deleteUser
          27. getAllNonPrivateRoles
          28. getAllNonPrivateRolesByTenant
          29. getAllNonPrivateRolesIDByTenant
          30. getAllProfiles
          31. getAllProfilesByClientLicenseType
          32. getAllProfilesByClientLicenseTypeByTenantId
          33. getAllProfilesByTenantId
          34. getAllRoles
          35. getAllRolesByProfileId
          36. getAllRolesByUser
          37. getAllTenants
          38. getAllUsersByCurrentTenant
          39. getAllUsersByTenant
          40. getAllUsersDataByTenantAndLicenceType
          41. getAvailableTenantLicenseCount
          42. getDefaultTenant
          43. getGroupsByRole
          44. getLicenseCount
          45. getLicenseCount2
          46. getLicenseExpirationDate
          47. getLicenseValidationStatus
          48. getMe
          49. getPrivateProfileIdForUser
          50. getRoleById
          51. getRolesByName
          52. getTenantByName
          53. getUser
          54. getUserByOpenIdPrincipalName
          55. getUserBySamlPrincipalName
          56. getUserLastLogin
          57. getUserStatusById
          58. getUserStatusByName
          59. getUsersByName
          60. getUsersByRole
          61. searchAdGroups
          62. searchAdGroupsForUser
          63. searchAdUsers
          64. searchAdUsersForGroups
          65. setUserAdministrationLevel
          66. toggleEnableUser
          67. updateDomainAdminPermissions
          68. updateRolesByProfileId
          69. updateTenant
          70. updateTenantSeats
          71. updateUserAd
          72. updateUserDb
          73. updateUserOpenId
          74. updateUserRoles
          75. updateUserSaml
          76. updateUsersAd
          77. updateUsersDb
          78. updateUsersOpenId
          79. updateUsersPhones
          80. updateUsersSaml
        2. Auth APIs
          1. authenticateUser
          2. authenticateUserByToken
          3. authenticateUserEmbed
          4. authenticateUserEmbedByToken
          5. authenticateUserEmbedOPENID
          6. authenticateUserEmbedSAML
          7. authenticateUserEmbedWindows
          8. authenticateUserOPENID
          9. authenticateUserOPENIDAlt
          10. authenticateUserSAML
          11. authenticateUserSAMLAlt
          12. authenticateUserWindows
        3. Content APIs
          1. addContentItemsToFavorites
          2. addRoleToItem
          3. addTag
          4. addTagToItem
          5. changeItemDescription
          6. changeItemFolder
          7. copyItems
          8. createNewFolder
          9. deleteTag
          10. exportContent
          11. exportContent2
          12. exportHub
          13. findContentItem
          14. findItemsByTagId
          15. findItemsByTagName
          16. getAllItemTags
          17. getAllItemsCreatedByUser
          18. getAllTags
          19. getAllTagsData
          20. getAllUserContentItems
          21. getAutoRecommendedItems
          22. getContentItemMetaData
          23. getContentItemSecurityRoles
          24. getContentItemSecurityRolesID
          25. getFavoriteItems
          26. getFolderItems
          27. getItem
          28. getMostUsedItems
          29. getPrivateFolderForUser
          30. getPrivateRootFolder
          31. getPublicOrGroupFolderByTenantId
          32. getRecentItems
          33. getRecommendedItems
          34. getTag
          35. getUserGroupFolders
          36. getUserGroupRootFolder
          37. getUserPrivateFolder
          38. getUserPrivateRootFolder
          39. getUserPublicFolders
          40. getUserPublicRootFolder
          41. importContent
          42. importHub
          43. moveItems
          44. purgeContentItems
          45. removeContentItemsFromFavorites
          46. removeRolesFromItem
          47. removeTagFromItem
          48. renameItem
          49. restoreSoftDeletedContentItems
          50. softDeleteContentItems
        4. Datasources APIs
          1. addHierarchyOverlayToModel
          2. addHierarchySecurityToModel
          3. addMeasureOverlayToModel
          4. addMeasureSecurityToModel
          5. addMembersSecurityToModel
          6. addRolesToDataBase
          7. addRolesToItemAndBubbleUp
          8. addRolesToItemAndPropagate
          9. addRolesToModel
          10. addRolesToServer
          11. changeDataSource
          12. changeDataSources
          13. createDataServer
          14. createDataServers
          15. deleteDataBase
          16. deleteDataSource
          17. deleteHierarchyOverlayFromModel
          18. deleteHierarchySecurityFromModel
          19. deleteMaterializedModel
          20. deleteMeasureOverlayFromModel
          21. deleteMeasureSecurityFromModel
          22. deleteMembersSecurityFromModel
          23. deleteRolesFromDatabase
          24. deleteRolesFromModel
          25. deleteRolesFromServer
          26. executeMasterFlow
          27. exportMaterializedModelDataCatalog
          28. exportModel
          29. findDatabaseByName
          30. findModelByName
          31. findServerByName
          32. getAllConnectionStrings
          33. getDataModelStructure
          34. getDataSourcesByTenant
          35. getDataSourcesByUserId
          36. getDatasourceUsedTables
          37. getHierarchySecurity
          38. getItemConnectionString
          39. getMasterFlowProgressUpdate
          40. getMasterFlowVariables
          41. getMeasureSecurity
          42. getMemberSecurity
          43. getModelHierarchyOverlay
          44. getModelMeasureOverlay
          45. getPulseNodesForTenant
          46. getRolesByDataBase
          47. getRolesByModel
          48. getRolesByServer
          49. getServerDataById
          50. getSourceByNodeId
          51. getTargetByNodeId
          52. getUserDataCatalog
          53. importMaterializedModelDataCatalog
          54. importModel
          55. recognizeDataBase
          56. recognizeModel
          57. searchConnectionString
          58. updateDataFlowNodeSchemas
          59. updateModelName
          60. updateModelProcessDate
          61. updateSourceNodeConnection
          62. updateTargetNodeConnection
          63. updateVariableConnection
          64. updateVariableValue
          65. validateMasterFlow
        5. Notification APIs
          1. getNotificationIndicators
        6. Query APIs
          1. extractNlpQueryResult
          2. extractQueryResult
          3. getParameterElements
        7. Tasks APIs
          1. deleteSchedule
          2. findSchedule
          3. getExecutions
          4. getScheduleExecutionStatus
          5. getSchedulesForUser
          6. getTaskData
          7. getTaskOutputs
          8. getTaskOutputsForUser
          9. getTasks
          10. getTasksIds
          11. reRunTask
          12. resumeSchedule
          13. runOnDemandSchedules
          14. runSchedule
          15. suspendSchedule
        8. Themes APIs
          1. applyTheme
          2. exportTheme
          3. findThemeByName
          4. importTheme
      7. API Objects and Enumerations
        1. API Object Definitions
          1. AddHierarchyOverlayApiObject
          2. AddMeasureOverlayApiObject
          3. AddUserRoleData
          4. AddUsersRoleData
          5. AdditionalServerProperties
          6. AdminMultiTenantData
          7. AdminTypeApiData
          8. AnalystProfileApiData
          9. AnalyticsPermissions
          10. ApiResultLicenseStatus
          11. ApiResultTaskStatus
          12. AttributeTranslation
          13. BaseUserOpenIdCredentials
          14. BaseUserSamlCredentials
          15. CartesianCategoriesDropZone
          16. CartesianCategoriesHierarchyChip
          17. CartesianColorChip
          18. CartesianColorDropZone
          19. CartesianColorHierarchyChip
          20. CartesianColorMeasureChip
          21. CartesianFilterChip
          22. CartesianFilterDropZone
          23. CartesianFilterHierarchyChip
          24. CartesianFilterValuesChip
          25. CartesianLabelsChip
          26. CartesianLabelsDropZone
          27. CartesianLabelsHierarchyChip
          28. CartesianLabelsMeasureChip
          29. CartesianMotionDropZone
          30. CartesianMotionHierarchyChip
          31. CartesianShapeChip
          32. CartesianShapeDropZone
          33. CartesianShapeHierarchyChip
          34. CartesianShapeMeasureChip
          35. CartesianSizeDropZone
          36. CartesianSizeMeasureChip
          37. CartesianTooltipChip
          38. CartesianTooltipDropZone
          39. CartesianTooltipHierarchyChip
          40. CartesianTooltipMeasureChip
          41. CartesianTrellisHorizontalChip
          42. CartesianTrellisHorizontalDropZone
          43. CartesianTrellisHorizontalHierarchyChip
          44. CartesianTrellisHorizontalValuesChip
          45. CartesianTrellisVerticalChip
          46. CartesianTrellisVerticalDropZone
          47. CartesianTrellisVerticalHierarchyChip
          48. CartesianTrellisVerticalValuesChip
          49. CartesianValuesDropZone
          50. CartesianValuesMeasureChip
          51. CartesianValuesVisualTypes
          52. CartesianVisual
          53. ChangeItemDescriptionData
          54. ChangeUserLicenseObject
          55. ConnStringDscApiObject
          56. ConnectedItemsSearchCriteria
          57. ConnectionSearchCriteria
          58. ConnectionStringData
          59. ConnectionStringProperties
          60. ContentSearchParamsObject
          61. CreateUserAdObject
          62. CreateUserDbObject
          63. CreateUserOpenIdObject
          64. CreateUserSamlObject
          65. CreatedThemeResult
          66. DataBaseRecognitionObject
          67. DataCatalogDimension
          68. DataCatalogHierarchy
          69. DataCatalogHierarchyLevel
          70. DataCatalogItem
          71. DataCatalogMeasure
          72. DataCatalogModelMetadata
          73. DataCatalogProperty
          74. DataCatalogUpdateData
          75. DataSourceTableResult
          76. DataSourceUsedTablesResult
          77. DeleteHierarchyOverlayApiObject
          78. DeleteMeasureOverlayApiObject
          79. DeleteTenantApiData
          80. DiscoverData
          81. DiscoverDataCatalog
          82. DomainAdminPermissionAPIObject
          83. DomainAdminPermissions
          84. DomainSecurityObject
          85. DscApiData
          86. ElementSelectionData
          87. EnumerationOutput
          88. ErrorMessage
          89. ExecuteMasterFlowObject
          90. ExecuteMasterFlowResult
          91. ExecuteScheduleApiData
          92. ExecutionSettings
          93. ExecutionViewData
          94. ExportContentApiData
          95. ExportData
          96. ExportOptions
          97. ExternalParameters
          98. FilterParameter
          99. FolderTenantObject
          100. FormulaData
          101. FtpSettings
          102. GetItemParamsObject
          103. GetOverlaySecurityObject
          104. GridColorChip
          105. GridColorDropZone
          106. GridColorHierarchyChip
          107. GridColorMeasureChip
          108. GridColsChip
          109. GridColsDropZone
          110. GridColsHierarchyChip
          111. GridColsValuesChip
          112. GridFilterChip
          113. GridFilterDropZone
          114. GridFilterHierarchyChip
          115. GridFilterValuesChip
          116. GridIndicatorDropZone
          117. GridIndicatorMeasureChip
          118. GridRowsChip
          119. GridRowsDropZone
          120. GridRowsHierarchyChip
          121. GridRowsValuesChip
          122. GridSizeDropZone
          123. GridSizeMeasureChip
          124. GridTooltipChip
          125. GridTooltipDropZone
          126. GridTooltipHierarchyChip
          127. GridTooltipMeasureChip
          128. GridValuesDropZone
          129. GridValuesMeasureChip
          130. GridVisual
          131. HierarchyElementSelection
          132. HierarchyMeasureSecurity
          133. HierarchyMeasureSecurityApiObject
          134. HierarchyOverlayData
          135. HierarchyOverlayToDeleteData
          136. HubApiObject
          137. ImportApiResultObject
          138. ImportMaterializedModelObject
          139. ItemId
          140. ItemParentApiData
          141. ItemRolePair
          142. ItemRolesForRemoval
          143. ItemRolesToBeAdded
          144. ItemsForFavorites
          145. ItemsToCopy
          146. ItemsToMove
          147. LdapGroupDetails
          148. LdapGroupIdentifier
          149. LdapSearchObject
          150. LdapUserObject
          151. LdapUsersSearchObject
          152. LicenseCountObject
          153. ListData
          154. MSOlapProperties
          155. MapColorChip
          156. MapColorDropZone
          157. MapColorHierarchyChip
          158. MapColorMeasureChip
          159. MapDetailsDropZone
          160. MapDetailsHierarchyChip
          161. MapFilterDropZone
          162. MapFilterHierarchyChip
          163. MapLocationChip
          164. MapLocationDropZone
          165. MapLocationHierarchyChip
          166. MapLocationMeasureChip
          167. MapMotionDropZone
          168. MapMotionHierarchyChip
          169. MapSizeDropZone
          170. MapSizeMeasureChip
          171. MapTooltipChip
          172. MapTooltipDropZone
          173. MapTooltipHierarchyChip
          174. MapTooltipMeasureChip
          175. MapVisual
          176. MasterFlowFindDataSourceObject
          177. MasterFlowModelNameObject
          178. MasterFlowOtherObject
          179. MasterFlowProgressResult
          180. MasterFlowSchemasObject
          181. MasterFlowSourceConnectionObject
          182. MasterFlowSourceObject
          183. MasterFlowTargetConnectionObject
          184. MasterFlowTargetObject
          185. MasterFlowUpdatedVariableResult
          186. MasterFlowValidationResult
          187. MasterFlowVariableConnectionObject
          188. MasterFlowVariableObject
          189. MasterFlowVariableValueObject
          190. MasterFlowVariablesResult
          191. MasterFlowVariablesValueObject
          192. MaterializedApiObject
          193. MaterializedItemObject
          194. MeasureGroup
          195. MeasureOverlayData
          196. MeasureOverlayToDeleteData
          197. MemberDataApi
          198. MembersSecurity
          199. MembersSecurityApiObject
          200. MetaDataTranslation
          201. ModelDataCatalog
          202. ModelDataFlowSourceInfo
          203. ModelProcessDateObject
          204. ModelProcessDateResult
          205. ModelRecognitionObject
          206. ModelScheduleOnDemandObject
          207. ModelScheduleOnDemandResult
          208. ModelSyncColumnsSettings
          209. ModelingAggregationMapping
          210. ModelingColumn
          211. ModelingConfigTranslation
          212. ModelingFolderTranslations
          213. ModelingHierarchy
          214. ModelingHierarchyLevel
          215. ModelingMeasure
          216. ModelingModel
          217. ModelingProperty
          218. ModelingRelationship
          219. ModelingRelationshipColumnPair
          220. ModelingServerInfo
          221. ModelingTable
          222. ModelingTranslation
          223. ModifiedItemsResult
          224. NewFolderApiData
          225. NlpQueryExportData
          226. NotificationIndicatorsResult
          227. OauthDataSourceSettings
          228. OdbcDirectQueryOptions
          229. PieApiObject
          230. ProPermissions
          231. ProProfileApiData
          232. ProfileApiData
          233. ProfilePermissionHolder
          234. ProfileRolesData
          235. ProfileTenant
          236. PulseClientData
          237. PyramidContentItem
          238. PyramidItemIdentifier
          239. PyramidViewUserObject
          240. QueryExportData
          241. QueryOptions
          242. QueryTotalSettings
          243. RelatedItemData
          244. RenameItemApiData
          245. RoleAdGroupsModifyObject
          246. RoleData
          247. RoleMinimalData
          248. RoleToItemApiData
          249. RolesInItemRemovalObject
          250. ScatterColorChip
          251. ScatterColorDropZone
          252. ScatterColorHierarchyChip
          253. ScatterColorMeasureChip
          254. ScatterDetailsDropZone
          255. ScatterDetailsHierarchyChip
          256. ScatterFilterChip
          257. ScatterFilterDropZone
          258. ScatterFilterHierarchyChip
          259. ScatterFilterValuesChip
          260. ScatterLabelsChip
          261. ScatterLabelsDropZone
          262. ScatterLabelsHierarchyChip
          263. ScatterLabelsMeasureChip
          264. ScatterMotionDropZone
          265. ScatterMotionHierarchyChip
          266. ScatterShapeChip
          267. ScatterShapeDropZone
          268. ScatterShapeHierarchyChip
          269. ScatterShapeMeasureChip
          270. ScatterSizeDropZone
          271. ScatterSizeMeasureChip
          272. ScatterTooltipChip
          273. ScatterTooltipDropZone
          274. ScatterTooltipHierarchyChip
          275. ScatterTooltipMeasureChip
          276. ScatterTrellisHorizontalChip
          277. ScatterTrellisHorizontalDropZone
          278. ScatterTrellisHorizontalHierarchyChip
          279. ScatterTrellisHorizontalValuesChip
          280. ScatterTrellisVerticalChip
          281. ScatterTrellisVerticalDropZone
          282. ScatterTrellisVerticalHierarchyChip
          283. ScatterTrellisVerticalValuesChip
          284. ScatterVisual
          285. ScatterXValuesDropZone
          286. ScatterXValuesMeasureChip
          287. ScatterYValuesDropZone
          288. ScatterYValuesMeasureChip
          289. ScheduleSearchCriteria
          290. ScheduleViewObject
          291. ScientistPermissions
          292. ScientistProfileApiData
          293. SearchAdGroupUsersData
          294. SearchAdUserGroupsData
          295. SearchCriteria
          296. SegmentColorChip
          297. SegmentColorDropZone
          298. SegmentColorHierarchyChip
          299. SegmentColorMeasureChip
          300. SegmentDetailsDropZone
          301. SegmentDetailsHierarchyChip
          302. SegmentFilterChip
          303. SegmentFilterDropZone
          304. SegmentFilterHierarchyChip
          305. SegmentFilterValuesChip
          306. SegmentLabelsChip
          307. SegmentLabelsDropZone
          308. SegmentLabelsHierarchyChip
          309. SegmentLabelsMeasureChip
          310. SegmentMotionDropZone
          311. SegmentMotionHierarchyChip
          312. SegmentSizeDropZone
          313. SegmentSizeMeasureChip
          314. SegmentTooltipChip
          315. SegmentTooltipDropZone
          316. SegmentTooltipHierarchyChip
          317. SegmentTooltipMeasureChip
          318. SegmentTrellisHorizontalChip
          319. SegmentTrellisHorizontalDropZone
          320. SegmentTrellisHorizontalHierarchyChip
          321. SegmentTrellisHorizontalValuesChip
          322. SegmentTrellisVerticalChip
          323. SegmentTrellisVerticalDropZone
          324. SegmentTrellisVerticalHierarchyChip
          325. SegmentTrellisVerticalValuesChip
          326. SegmentValuesDropZone
          327. SegmentValuesMeasureChip
          328. SegmentVisual
          329. ServerData
          330. SimpleModifierResult
          331. TabularColorChip
          332. TabularColorDropZone
          333. TabularColorHierarchyChip
          334. TabularColorMeasureChip
          335. TabularColsChip
          336. TabularColsDropZone
          337. TabularColsHierarchyChip
          338. TabularColsMeasureChip
          339. TabularFilterDropZone
          340. TabularFilterHierarchyChip
          341. TabularSizeDropZone
          342. TabularSizeMeasureChip
          343. TabularTooltipChip
          344. TabularTooltipDropZone
          345. TabularTooltipHierarchyChip
          346. TabularTooltipMeasureChip
          347. TabularVisual
          348. TagData
          349. TagUsageApiData
          350. TargetParameter
          351. TaskSummary
          352. TaskUserApiData
          353. TaskViewData
          354. TenantLicenseTypeData
          355. TenantObject
          356. TenantSettings
          357. TenantUsersGetObject
          358. ThemeApiObject
          359. ThemeListObject
          360. ThemeToItemsApiObject
          361. ToggleUserApiData
          362. TotalsSettings
          363. UpdateTenantSeatsObject
          364. UpdateUserAdObject
          365. UpdateUserDbObject
          366. UpdateUserOpenIdObject
          367. UpdateUserSamlObject
          368. UserCredentials
          369. UserOpenIdCredentials
          370. UserPhone
          371. UserRolesData
          372. UserSamlCredentials
          373. UserTokenCredentials
          374. ViewerPermissions
          375. ViewerProfileApiData
          376. Visuals
        2. API Enumeration Definitions
          1. AccessType
          2. AdminType
          3. AggregationType
          4. AnalystPermissionOptions
          5. ApiResponseFormat
          6. AxisTotalsType
          7. BulkWritingType
          8. BwDatabaseListType
          9. BwInfoAreaTreeViewType
          10. CartesianBarVisualType
          11. CartesianColumnVisualType
          12. CartesianLineVisualType
          13. CartesianStackedBarVisualType
          14. CartesianStackedColumnVisualType
          15. CartesianVisualType
          16. ClashDefaultOption
          17. ClientLicenseType
          18. ColorMathFunction
          19. ConditionConjunctionType
          20. ConnectionStringType
          21. ContentItemObject
          22. ContentType
          23. ContentTypeObject
          24. CsvDelimiter
          25. CubeAuthMethod
          26. CustomRootCAType
          27. DataFlowModelType
          28. DataType
          29. DomainAdminPermissionType
          30. ElementSelectionDataType
          31. EtlSyncModelColumnsType
          32. FilterHierarchyType
          33. FilterValuesType
          34. FirstWorkday
          35. FtpDataMode
          36. FtpSecurityType
          37. GaType
          38. GridColorOption
          39. HideMemberType
          40. HierarchyCategory
          41. HierarchyOverlayProperty
          42. HierarchyType
          43. IsolationMode
          44. ItemType
          45. JoinType
          46. KpiAttributeType
          47. LanguageType
          48. LdapSearchType
          49. LicenseStatus
          50. MapVisualType
          51. MaskingMethodType
          52. MaterializedItemType
          53. MeasureFormat
          54. MeasureMapOptions
          55. MeasureOverlayProperty
          56. ModelAttributeType
          57. ModelingColumnCategories
          58. ModelingColumnType
          59. ModelingTableType
          60. MsOlapConnectionType
          61. OpenIdAuthType
          62. OperatorType
          63. PaperType
          64. ParentChildOrphans
          65. ParentChildRollupType
          66. PermissionBitIndex
          67. PrintingOutputType
          68. ProPermissionOptions
          69. QueryCacheMode
          70. QueryTotalPosition
          71. RoleAssignment
          72. RoleAssignmentType
          73. RootFolderType
          74. SapBwServerConnectionType
          75. ScatterVisualType
          76. ScheduleDataType
          77. ScheduleStatus
          78. ScheduleType
          79. ScientistPermissionOptions
          80. SearchMatchType
          81. SearchRootFolderType
          82. SecurityType
          83. SegmentVisualType
          84. ServerAuthenticationMethod
          85. ServerEffectiveUserName
          86. ServiceStatus
          87. SizeDropZoneOptions
          88. SizeMathFunction
          89. SparkTransportMode
          90. SyntaxType
          91. TagType
          92. TaskStatus
          93. UpdateSchemaValidation
          94. UserProfileType
          95. UserStatus
          96. ValidRootFolderType
          97. ValuesDropZoneOptions
          98. VariableType
          99. ViewerPermissionOptions
    2. Custom Visual API
      1. Custom Visual APIs 2.0
        1. Getting Started with the CV API
          1. Custom Visual Example - Aster Plot
        2. CvApi2
          1. Canvas
            1. Style
          2. ResultSet
            1. Data
              1. TrellisData
                1. Datapoint
                  1. Numerics
                    1. Value
            2. Dropzone
              1. Chip
                1. Element
          3. VisualConfig
          4. Utils
          5. ExternalLibraries
            1. D3Libraries
            2. UtilsLibraries
          6. Enums
            1. ChipType
            2. ColorRangeType
            3. DropZoneType
            4. Event
    3. Custom WorkFlow API
      1. Using the WorkFlow API
        1. Custom Workflow API Example
      2. Workflow API Overview
      3. WorkflowApi
        1. Canvas
        2. WorkflowThread
          1. Entry
            1. Attachment
          2. Contact
        3. Session
        4. Utilities
        5. ExternalLibraries
        6. Enums
          1. AttachmentType
          2. ContactType
          3. ThemeType
          4. WorkflowThreadType

Video Tutorials

  1. Pro Videos
    1. Model Videos
    2. Discover Videos
      1. Discover Visualization Videos
      2. Discover Analytics Videos
    3. Present Videos
    4. Publish Videos
    5. Formulate Videos
    6. Tabulate Tutorial Videos
    7. Illustrate Videos
    8. Content Manager Videos
    9. Admin Videos
  2. Analyst Videos
  3. Viewer Videos

Pyramid Analytics © 2017-2024